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:
csgpro.com/contact/
Visit our blog:
csgpro.com/blog/
- Elements of DAX 06-07: Override Filtering with CALCULATE() (A) ( Download)
- Elements of DAX 06-08: Override Filtering with CALCULATE() (B) ( Download)
- Elements of DAX 06-14 Override Filters In Measures ( Download)
- Elements of DAX 06-04: Override Filter Concepts ( Download)
- Elements of DAX 06-10: Current Row Filtering with Measures ( Download)
- Elements of DAX 06-09: Current Row Filtering with CALCULATE() ( Download)
- Elements of DAX 06-06: Current Row Puzzle (Optional) ( Download)
- Elements of DAX 06-01: Filter Reviser Concepts ( Download)
- Elements of DAX 04-06: Derivation Corner Cases ( Download)
- Elements of DAX 06-17 CALCULATE() With Two Aggregators ( Download)
- Elements of DAX 06-18 CALCULATE() Then Another CALCULATE() ( Download)
- DAX in 10! Episode 4: The CALCULATE Function ( Download)
- CALCULATE, CALCULATETABLE - DAX Guide ( Download)
- KEEPFILTERS - DAX Guide ( Download)
- How to use KEEPFILTERS with CALCULATE in Power BI ( Download)