Elements of DAX 06-07: Override Filtering with CALCULATE() (A)

The simplest of simple Filter Revision, using the CALCULATE() function with only Override filters is a great place to start. In this video Brian Grant will show you how CALCULATE() evaluates its additional arguments into Temp Tables in order to add them to the Filter Context; getting the filters just right before unfreezing and running its Sub Expression. This video will help you look at CALCULATE() and understand the purpose of each argument and the order that they run in. Mastering this makes scanning code quickly much, much easier.

------------
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:

[rick_.]

Thank you, was very much looking forward to this next batch of videos. One thing that I find have to keep reminding myself is that row context exists only inside iterators and calculated columns.