Table of Contents
In Power BI, you can ignore a filter for a measure by using the “Edit Interactions” feature. This allows you to specify which filters should be applied to a specific measure. By selecting “None” for the filter interaction, the measure will not be affected by any filters applied to the visual. This can be useful when you want to display a measure without it being affected by other filters, providing a more accurate representation of the data.
You can use the ALL function when creating a measure in Power BI to ignore filters in a report view.
For example, you can use the following syntax in DAX to create a measure named Max Points that calculates the max value in the Points column of a table while ignoring any filters on the Team column:
Max Points = CALCULATE(MAX('my_data'[Points]),ALL('my_data'[Team]))
The following example shows how to use this syntax in practice.
Example: How to Ignore Filter for a Measure in Power BI
Suppose we have the following table in Power BI named my_data that contains information about points scored by basketball players on various teams:
Suppose we would like to calculate the max value in the Points column.
To do so, click the Table tools tab along the top ribbon, then click the New measure icon:
Now suppose we type the following formula into the formula bar:
Max Points = MAX('my_data'[Points])
This will create a new measure named Max Points that contains the max value in the Points column of the table:
Now suppose we switch to the report view and add a card that displays the value of this measure:
We can see that the max value in the Points column is 34.
In order to create a measure that ignores this filter, we must use the following syntax instead:
Max Points = CALCULATE(MAX('my_data'[Points]),ALL('my_data'[Team]))
This will create a new measure named Max Points that contains the max value in the Points column of the table and ignores any filters on the Team column:
Now if we filter once again for the Mavs team in the report view, then the max value shown in the card visualization will still be 34 since this represents the max of all values in the Points column:
Note: You can find the complete documentation for the CALCULATE function in DAX .
Additional Resources
The following tutorials explain how to perform other common tasks in Power BI: