ISCROSSFILTERED DAX Function in Power BI

The ISCROSSFILTERED is a DAX function that checks whether a specified column or Table is affected by a direct filter or indirect filter in the current filter context. It returns a Boolean value:
• TRUE: If the column or Table is impacted by a filter, either directly or indirectly through relationships between tables.
• FALSE: If the column or Table is not affected by any filters in the current context.

Unlike ISFILTERED, which only detects direct filters on a column or Table (e.g., from a slicer or filter pane), ISCROSSFILTERED is broader—it accounts for filters propagated through table relationships, making it essential for understanding how filters flow across our data model.

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 as well as the filters propagated through relationships.
• 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 “ISCROSSFILTERED Measure” and assign it to the Card visual as shown in the image.

DAX

The “ISCROSSFILTERED 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. And, the measure returns True, as it is indirectly filtered by the “Branch Table”.

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. Also, we can see that the measure returns True, as it is indirectly filtered by the “Teachers Table”.

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.