Relationships, Pivots, and DAX: The Payoff of Power BI Data Modeling, Part Two

Kristi Cantor

(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 to slice Plays data by ANY column in CleanPlayers (and there was much rejoicing).  But wait, there’s more!

And this time, I’m gonna try my hand at a video post.  Here goes…

Would love feedback on this method vs. text-and-images.  Strong preference for one or the other?  Hybrid?

Is the video resolution sufficient for everyone?  Windows Movie Maker was giving me any size video I wanted, as long as it was 30 MB 😛  Might need another tool 🙂

Update:  OMG that resolution is terribad.  Gonna try again in the morning with a different toolset, it was better on my desktop even at 30 MB.

So I’m taking the vid down for now.

Read more on our blog

Get in touch with a P3 team member

  • This field is hidden when viewing the form
  • This field is hidden when viewing the form
  • This field is for validation purposes and should be left unchanged.

Stay in the know.

This field is for validation purposes and should be left unchanged.

Related Content

Jittered Scatter Charts in Power BI via DAX and Power Query

In a recent post, I hinted that I’d be using the Football

Read the Blog

DAX – More Fun With IF(VALUES())

“I mean, IF() I’m paying top dollar, I want a little production

Read the Blog

DAX – The Magic of IF(VALUES())

“I’m Dan Marino, and IF() anyone knows the VALUE() of protection, it’s

Read the Blog

Quick Tip: Don’t Over-Use DAX FILTER() function in Power BI

The other day I was working on an updated version of my

Read the Blog