Use this DAX check to learn whether any filter reaches a column or table, either applied straight to it or flowing in from a related table; it gives TRUE if so.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains ISCROSSFILTERED in context, with comparison tables and the common traps.
Terms in this definition
- DAX
Short for Data Analysis Expressions, the formula language you write measures, calculated columns and row-level security rules in, within tabular semantic models in Power BI, Excel Power Pivot or Analysis Services.
- FILTER
Returns just those rows of a table that meet a condition. In CALCULATE it handles conditions too complex for a Boolean filter argument, though a Boolean filter is faster whenever one will work.
- Event
Table in Log Analytics where entries from Windows event logs are kept.
- RELATED
Fetches a column value from the lookup table, that is the one side of a many-to-one relationship, for whichever row is being evaluated. It therefore needs to run inside an iterator or a calculated column, where row context exists.
Related terms
- Information functions
ISBLANK, ISFILTERED, ISCROSSFILTERED, ISINSCOPE and HASONEVALUE all belong to this DAX family, whose members inspect a value or check what filters currently apply.
- ISFILTERED
Returns TRUE in DAX only when a column or table has a filter placed directly on it; filters arriving via relationships are ignored here but are detected by ISCROSSFILTERED.