TechNet
Export (0) Print
Expand All

ISCROSSFILTERED Function (DAX)

 

Returns TRUE when columnName or another column in the same or related table is being filtered.

Syntax

ISCROSSFILTERED(<columnName>)

Parameters

columnName
The name of an existing column, using standard DAX syntax. It cannot be an expression.

Return Value

TRUE when columnName or another column in the same or related table is being filtered. Otherwise returns FALSE.

Remarks

  • A column is said to be cross-filtered when a filter applied to another column in the same table or in a related table affects columnName by filtering it. A column is said to be filtered directly when the filter or filters apply over the column.

  • The related function ISFILTERED Function (DAX) returns TRUE when columnName is filtered directly.

See Also

ISFILTERED Function (DAX)
FILTERS Function (DAX)
HASONEFILTER Function (DAX)
HASONEVALUE Function (DAX)

Community Additions

Show:
© 2016 Microsoft