Filter Context is one of the most important concepts in DAX. It refers to the set of data that is currently filtered when a calculation is performed.<\/p>\n\n\n\n
In simple terms, Filter Context means calculations change based on filters applied in a report.<\/p>\n\n\n\n
Filters can come from:<\/p>\n\n\n\n
Consider the following measure:<\/p>\n\n\n\n
Total Sales = SUM(Sales[Amount])<\/pre>\n\n\n\nIf you place this measure in a card visual, it will show total sales for all data.<\/p>\n\n\n\n
If you add a slicer for Year and select 2024, the measure will automatically show sales only for 2024.<\/p>\n\n\n\n
The formula does not change, but the result changes because the Filter Context changes.<\/p>\n\n\n\n
Filter Context in Visuals<\/h2>\n\n\n\n
When you use a visual like a table with Region and Total Sales:<\/p>\n\n\n\n
Each row in the visual creates a different Filter Context.<\/p>\n\n\n\n
The CALCULATE function allows you to change or override the existing Filter Context.<\/p>\n\n\n\n
Sales 2024 = CALCULATE(
SUM(Sales[Amount]),
Sales[Year] = 2024
)<\/pre>\n\n\n\nThis measure forces the calculation to consider only data where Year = 2024, regardless of other filters.<\/p>\n\n\n\n
Filter Context vs Row Context<\/h2>\n\n\n\n
Row Context works one row at a time.<\/p>\n\n\n\n
Filter Context works on filtered sets of data.<\/p>\n\n\n\n
Measures mainly work with Filter Context.
Calculated Columns mainly work with Row Context.<\/p>\n\n\n\nWhy Filter Context is Important<\/h2>\n\n\n\n
\n
- Makes reports dynamic and interactive<\/li>\n\n\n\n
- Allows calculations to respond to slicers and filters<\/li>\n\n\n\n
- Essential for time intelligence and advanced DAX<\/li>\n\n\n\n
- Required for building KPIs and dashboards<\/li>\n<\/ul>\n\n\n\n
Conclusion<\/h2>\n\n\n\n
Filter Context controls which data is included in a calculation. Understanding it is essential for writing effective DAX measures and building powerful Power BI reports.<\/p>\n\n\n\n
<\/strong><\/p> <\/div> <\/div>\n\n\n