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

  • Implement Non Visual Totals with Power BI security roles

    This article describes how to implement non-visual-totals with security roles in Power BI and Analysis Services Tabular, which by default show only visual totals of measures in the model. » Read more

  • Optimizing duplicated DAX expressions using variables

    This article describes how to use variables to optimize the performance of DAX expressions containing multiple instances of the same measure or the same sub-expression. » Read more

Related functions

Other related functions are:

Last update: Jan 11, 2021   » Contribute   » Show contributors

Contributors: Alberto Ferrari, Marco Russo

MSDN documentation:

2018-2021 © SQLBI. All rights are reserved. Information coming from MSDN is property of Microsoft Corp. » Contact us   » Privacy Policy & Cookies

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.

DirectQuery compatibility

Limitations are placed on DAX expressions allowed in measures and calculated columns.
The state below shows the DirectQuery compatibility of the DAX function.


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.