Elements of DAX 06-11: Current Row Filtering Comparison

Sometimes an important idea is worth seeing a couple times. In this video Brian Grant will walk you through a couple more examples of Current Row Filtering, but more importantly he will demonstrate the similarities of Measures and the CALCULATE() function. We will also see what happens mechanically when Filter Revision is needed in a formula but is not used. It's so very easy to forget about Current Row Filtering when you're new and this video should help cement these important ideas.

------------
Don't forget to subscribe to our channel for the latest Power BI, Power Platform, Azure, and Data Analytics content.

At CSG Pro, we love learning and sharing new technologies, processes, and solutions to help you be victorious in your role.

Work with us:

Visit our blog:

[TD-mpnf]

Brian is obviously aware of the mechanism for forming stable skills - multiple repetitions (e.g., to remember a foreign word 30 repetitions required in different contexts). He is explaining the same concepts from different perspectives. He goes through the same routine again and again without skipping a single step, without assuming that viewers understand and remember from previous examples. Brilliant teaching.

[rjm]

This is by far the best DAX study I have taken. Thank you Brian for your excellent approach to teaching a difficult subject. When can your "groupies" expect #46?

[pdadey]

Brian is the spreadsheet used in the example publically available?

[seanmen]

Great tutorial Brian! Just wondering if you are going to explain what will happen if there is existing filter context? For example how it will work when you grab this measure into a pivot table where the Shift or Dish is in rows.