Row vs Filter Context in PowerBI

Gaining an understanding of Row and Filter Context is among the most difficult challenges facing a new DAX author. Just when you think you’ve got it, a problem arises and your hard-won mental model seems to crumble before your eye. For a new author this is particularly tricky in that virtually everything beyond the most trivial measures relies heavily on these concepts; forcing most new folks to resort to memorizing patterns until that mental model develops naturally.

In this video, we’re going to attempt to jumpstart that process. This isn’t a strict technical definition (I simplify a few things), but rather a beginner friendly mental model designed to get you up and running with DAX while still giving you a solid sense of what’s happening under the hood.

BTW, I squeeze a lot of data on this page; so, unlike most of my videos you’re going to want to watch this one in full 1080 (look for the gear at the bottom right of the YouTube player), preferably on a decent sized monitor.

Happy Reporting!

Share This:
Twitter
Facebook
LinkedIn

Stay up to date with the latest customer data news, expert guidance, and resources.

Iteration and Error Handling in M Query

All iteration roads in M Query eventually lead to the List.Generate function. In strengthening our data manipulation skills through Power Query, we absolutely need this looping function.

More Resources

Trusted By Over 6 Million End Users​

Industry leaders and over 6 million end users choose SkyPoint as their comprehensive and compliant Modern Data Stack Platform. A Gold Certified Microsoft Partner, SkyPoint Cloud turns siloed customer data into connected customer experiences.