The ISCROSSFILTERED function returns the logical value True when the column indicated as an argument is being filtered directly or crossed by another column in the same table or in a related table.
ISCROSSFILTERED(
column
)
- column: Name of an existing column. It cannot be a DAX expression.
The ISCROSSFILTERED function returns a Boolean.
A column is said to be receiving a direct filter (or being filtered directly) when the filter or filters are applied directly to the column. On the contrary, it is said that a column receives a cross filter (or that it is being cross filtered) when the filter applied to another column of the same table or to a related table affects the column under analysis by filtering it as well.
We can find out if the City column of the Geography table receives a direct or cross filter with the following measure:
iscrossfiltered =
IF(
ISCROSSFILTERED(Geography[City]),
TRUE(),
FALSE()
)
By default, this measure returns the value False:
If we add a segmentation with the list of cities and select one, the previous measure returns True :
However, and contrary to what happens with the ISFILTERED function, if we deselect the city, we add a second segmentation with the list of countries and select one (which means that the list of cities is also filtered, albeit in a cross way), the measure also returns the value True:
