What is row context?

< 1 min read

Row context means DAX evaluates an expression one row at a time.
It is automatically available in calculated columns.
For example, Profit = Sales[Revenue] – Sales[Cost] works because each row is evaluated separately.
It also exists inside iterator functions like SUMX or FILTER.
In one project, I used SUMX to calculate total discounted revenue row by row.
Row context does not automatically aggregate data.
If we need aggregation, we combine it with functions like CALCULATE.
Understanding row context helps avoid errors when referencing columns in measures.

Power BI Essentials