What is evaluation context in DAX?

< 1 min read

Evaluation context in DAX defines how a calculation is evaluated.
It mainly includes row context and filter context.
Row context applies when calculating values row by row, like in calculated columns.
For example, Profit = Revenue – Cost works because DAX evaluates each row separately.
Filter context comes from slicers, filters, or visuals in the report.
For example, Total Sales changes when a user selects a specific year or region.
In one project, I used CALCULATE to modify filter context for YTD Sales.
Understanding evaluation context helps avoid incorrect totals and aggregation issues.

Power BI Essentials