Jittered Scatter Charts in Power BI via DAX and Power Query
In a recent post, I hinted that I’d be using the Football Project V2 as my “platform” for some future techniques-oriented posts. T
Category: The Great Football Project
DAX – More Fun With IF(VALUES())
“I mean, IF() I’m paying top dollar, I want a little production VALUE()” I bet you thought I was out of movie quotes for IF(VALUES()) didn’t you! If I had […]
DAX – The Magic of IF(VALUES())
“I’m Dan Marino, and IF() anyone knows the VALUE() of protection, it’s me.” Boom! An Ace Ventura quote finally graces the blog. Yes folks, that fine work of American cinema […]
Quick Tip: Don’t Over-Use DAX FILTER() function in Power BI
The other day I was working on an updated version of my Team Playcalling report, which, by the way, look FABULOUS with Slicers: Only problem with it was that it […]
RANK measure finished
“…I always see the job through.” -Angel Eyes Yep, I said I would return and finish off the Rank measure. Time to deliver. (And this makes three straight Spaghetti Western […]
Rank continued – dealing with unknown members
TUCO: “There’s no name on it!” BLONDIE: “Well, there’s no name here, either.” Ode to YouTube HD When I used to work on Bing and would look at search logs, […]
Introducing CUBESET() and CUBERANKEDMEMBER()
“Where does he get such WONDERFUL toys???” -Kasper de Jonge (To be honest, Kasper probably looks nothing like this. I’ve never been to the Netherlands, but based on the fashions […]
Parameterizing the report
In the Parameterized Report, how do I get the “Fan Pts” column on the far right of the cube formula report to respond to those parameter cells in the top […]
Pulling back the curtain: Intro to Cube Formulas
OK, last week I showed you a parameterized PowerPivot report that contained no pivots anywhere. How did I build it? Best Tutorial: Start with a Pivot The easiest way to […]
DAX’s CALCULATE() function – if you’re not using this in Power BI (or Excel), it’s time to start
When I last worked on the football project, I had designed my first report and started the process of better understanding my source data, primarily using the =RELATED() function.
Relationships, Pivots, and DAX: The Payoff of Power BI Data Modeling, Part Two
(Continuing the series on the Great Football Project…) OK, remember in the previous step, we saw how a relationship between Plays and CleanPlayers suddenly let me use a single PivotTable […]
Relationships, Pivots, and DAX: The Payoff of Power BI Data Modeling, Part One
Recall that in yesterday’s post I linked my FactEvent table to the CleanPlayers table via a relationship. Time for the payoff. But you know what? I’m tired of calling it […]