- Context transition happens when row context is converted into filter context.
- It usually occurs when we use CALCULATE inside a row context.
- For example, in a calculated column, using CALCULATE applies the current row as a filter.
- In one project, I calculated customer total sales inside a calculated column.
- CALCULATE converted the current Customer row into a filter on the Sales table.
- Without context transition, the measure would return the overall total instead of customer-level total.
- Understanding this is important when mixing calculated columns and measures.
- It helps avoid incorrect aggregations in complex DAX logic.
What is context transition in DAX?
Updated on February 23, 2026
< 1 min read