ISCROSSFILTERED DAX Function (Information)

Returns true when the specified table or column is crossfiltered.


ISCROSSFILTERED ( <TableNameOrColumnName> )
Parameter Attributes Description

The column or table to check the filter info.

Return values

Scalar A single boolean value.

TRUE when any column of the table specified or another column a related table is being filtered. Otherwise returns FALSE.


A column or table is said to be cross-filtered when a filter is applied to any column of the same table or in a related table.
A column is said to be filtered directly when the filter or filters apply over the column.

Related articles

Learn more about ISCROSSFILTERED in the following articles:

  • Clever Hierarchy Handling in DAX

    Hierarchy handling in DAX is not very easy, due to the fact that hierarchies, unlike it was in MDX, are not first-class citizens in the DAX world. While hierarchies can be easily defined in the data model, there are no DAX functions that let you access, for example, the parent of the CurrentMember. Well, to tell the truth, there is no concept of CurrentMember in DAX either. » Read more

Related functions

Other related functions are:

Last update: Oct 15, 2019   » Contribute   » Show contributors

Contributors: Alberto Ferrari, Marco Russo

MSDN documentation:

DAX Conventions
Context Transition

This function performs a Context Transition if called in a Row Context. Click to read more.

Row Context

This expression is executed in a Row Context. Click to read more.


Not recommended

The use of this function is not recommended. See Remarks and Related functions for alternatives.

Not recommended

The use of this parameter is not recommended.


This function is deprecated. Jump to the Alternatives section to see the function to use.


This parameter is deprecated and its use is not recommended.


Want to improve the content of ISCROSSFILTERED? Did you find any issue?
Please, report it us! All submissions will be evaluated for possible updates of the content.

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.