Back to Roadmap
Level 2 — Working With Filters+50 XP
Lesson 1
1. Filter Context
The invisible set of active filters driving every visual coordinate.
The Concept
Filter Context is the set of all active filters applied to the data model before evaluating a measure.
Example DAX:
// If a matrix visual has "Year = 2025" and "Country = Norway", // that IS the filter context for that specific cell! Total Revenue = SUM(Sales[Revenue])
Every cell in Power BI has its own unique filter context created by report slicers, visual axes, filters pane, and cross-filtering from other visuals.
Try It Yourself
Write a measure for 'Total Cost' that will naturally calculate within whatever filter context is active.
fx
[fx]Filter Context=
Loading DAX Formula Studio...
Type [ for fields