A fundamental knowledge for authors of DAX measures is the filter context in which the calculation logic of DAX measures is executed. The filter context is the set of rows for each table in the data model which are available to be evaluated for each value displayed in report visualizations. For example, each value of a Power BI chart that analyzes a sales amount measured by a Product Category column will usually be unique because a different set of rows (filter context) of the sales fact table was available to the measure when calculating each value.
In the following Power BI report, five distinct filters representing five dimension tables have been applied to a matrix visual of the Internet Gross Sales measure:
Filtered power ...
