ISCROSSFILTERED

ISCROSSFILTERED is a DAX function that returns TRUE when the specified table or column is cross-filtered.

Syntax

ISCROSSFILTERED( TableNameOrColumnName )

Argument	Properties	Description
TableNameOrColumnName		The column or table to check the filter info.

Return Values

TRUE when ColumnName or a column of TableName is being cross-filtered. Otherwise returns FALSE.

Remarks

• A column or table is said to be cross-filtered when a filter is applied to ColumnName, any column of TableName, or to any column of a related table.

• A column or table is said to be filtered directly when a filter is applied to ColumnName or to any column of TableName. Therefore, the ISFILTERED function also returns TRUE when ColumnName or any column of TableName is filtered.

• This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.

Empty

Related functions

Other functions related to ISCROSSFILTERED are:

• HASONEFILTER
• HASONEVALUE
• ISFILTERED
• ISINSCOPE
• ISSUBTOTAL

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/dax/iscrossfiltered-function-dax