Mastering Microsoft Power BI

Measure evaluation process

Each value in the report, such as the $600 from the matrix visual, is computed according to the following four-step process:

1. Initial Filter Context:
   • This includes all filters applied within and outside the report canvas by the report author
   • Selections on slicer visuals and the rows and columns of the table and matrix visuals represent on-canvas filters
   • Report, page, visual, and drillthrough filters represent off-canvas filters that also contribute to the initial filter context
2. Filter Context Modified via DAX:
   • For base measures and other simplistic expressions, the initial filter context from the report is left unchanged
   • For more complex measures, the CALCULATE() function is invoked to further modify the initial ...