ISFILTERED DAX Function in Power BI

The ISFILTERED is a DAX function that checks whether a specified column or Table in our data model has an active filter applied to it. It returns a Boolean value:
• TRUE: If the column is filtered (e.g., by a slicer, filter pane, or another DAX calculation).
• FALSE: If the column is not filtered.

DAX

The parameter TableNameOrColumnName specifies the name of an existing table or column. It cannot be an expression.

Points to note: • It checks direct filters on the column itself, not filters propagated through relationships (use ISCROSSFILTERED for that).
• It’s sensitive to the current evaluation context, so its result can change based on where it’s used (e.g., a measure in a visual).

Example: Let’s we have the following data model in the Power BI report.

Here, we can see that the “Branch Table” and Teacher are bidirectional filtered and “Branch Table” filters the “Students Table”.

Let’s we have three slicers and a bar chart and a card visual on the report page.

Let’s create a measure with name “ISFILTERED Measure” and assign it to the Card visual as shown in the image.

DAX

The “ISFILTERED Measure” check whether the “Students Table” is directly filtered or not. If it is directly filtered it returns True otherwise False. As of now without any filter on the table, it returns False.

Let’s filter the page by the help of ID No slicer of the “Branch Table”. We can see that the bar chart is filtered because of the relationship exist between them. But we can see that the measure returns False, as it is indirectly filtered but not directly filtered.

Let’s filter the page by the slicer that is attached to the ID column which is of the “Teacher Table”. We can see that the bar chart is filtered because of the relationship is propagated between the tables. But we can see that the measure returns False, as it is indirectly filtered but not directly filtered.

Let’s filter the page by the slicer that is attached to the “Branch ID” column of the “Students Table”. Now we can see that the bar chart is filtered as it is coming from the same table. And we can see that the measure returns True, as it is directly filtered.