Power BI · Chapter 45
DAX: CALCULATE Deep Dive and Filter Context Mastery
CALCULATE changes filter context — surgical clears, KEEPFILTERS, and context transition with small INR examples.
Fictional sample data for learning. Brands belong to their owners. Numbers are made up for class.
In this chapter
- Contrast filter context and row context in plain English.
- Explain what CALCULATE does to filters.
- Use REMOVEFILTERS/ALL patterns carefully.
- Apply KEEPFILTERS when overwrite is wrong.
- Describe context transition with an iterator example.
- Spot interview myths about CALCULATE.