ISCROSSFILTERED Function (DAX)

How does the ISCROSSFILTERED Function (DAX) work?

ISCROSSFILTERED Function (DAX) returns TRUE when columnName or another column in the same or related table is being filtered.

ISCROSSFILTERED Formula Syntax

ISCROSSFILTERED(<columnName>)

How do you use the ISCROSSFILTERED function?

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

Related Blog Posts

FILTER-CONTEXT
Using-Filter-Fields-Visual-Interactions-in-Power-BI-1
Understanding-Evaluation-Context-in-Power-BI

Related Support Forum Posts

Displaying/Hiding Measures in Hierarchies
Dynamic Formatting of Selected Measure
Default Slicer Selection

Considerations when using the ISCROSSFILTERED function

A column is said to be cross-filtered when filtering it affects columnName when a filter applies to another column in the same row, or in a different table. A column is said to be filtered directly over the column when the filter or filter is applied.

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

Related Video Tutorials

Filtering By Fiscal Or Financial Year Months & Quarters In Power BI
Simple Filters w CALCULATE - (1.13) Ultimate Beginners Guide to DAX
How-To-Use-Virtual-Tables-With-COUNTROWS-in-Power-BI-DAX-Formula-Technique

Formula examples using the ISCROSSFILTERED function

= ISCROSSFILTERED (Sales) 

Related DAX Functions

ISFILTERED
FILTERS
HASONEFILTER

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI

DOWNLOAD

To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.