ISCROSSFILTERED

Whether a table or column is filtered, directly or through another column or a relationship.

Group: Information. Compatible with DAX.

Syntax

ISCROSSFILTERED ( <TableNameOrColumnName> )

Parameter	Type	Description
`TableNameOrColumnName`	Table or column	A column, or a table: a table is cross-filtered when its columns are.

Returns

Boolean. TRUE when a filter reaches the column, on it or on another column whose filter flows to it.

Remarks

A column filtered directly counts as cross-filtered too. On top of that, a filter on another column of the same table reaches it (Products[Product] reaches Products[Category]), and so does a filter on a table that a relationship leads from (Products to Sales).
A filter does not flow against a relationship's direction: filtering Products leaves Places untouched, as Sales points to both but neither points on to the other.
Only filters count, not a row context; and a filter that ALL or REMOVEFILTERS removes no longer reaches anything.
To ask about filters on the column itself only, use ISFILTERED.

Examples

By product, with a total

The product filter of each row reaches the category, the sales rows, but not the places. On the total nothing is filtered.

EVALUATE
SUMMARIZECOLUMNS (
    ROLLUPADDISSUBTOTAL ( Products[Product], "Total" ),
    "Category filtered", ISFILTERED ( Products[Category] ),
    "Category cross-filtered", ISCROSSFILTERED ( Products[Category] ),
    "Sales cross-filtered", ISCROSSFILTERED ( Sales ),
    "Places cross-filtered", ISCROSSFILTERED ( Places[Kind] )
)
ORDER BY [Total], Products[Product]

Products[Product]	Total	Category filtered	Category cross-filtered	Sales cross-filtered	Places cross-filtered
Cider	FALSE	FALSE	TRUE	TRUE	FALSE
IPA	FALSE	FALSE	TRUE	TRUE	FALSE
Lettøl	FALSE	FALSE	TRUE	TRUE	FALSE
Pils	FALSE	FALSE	TRUE	TRUE	FALSE
(blank)	TRUE	FALSE	FALSE	FALSE	FALSE

ISFILTERED, HASONEVALUE, ALLCROSSFILTERED, CROSSFILTER, ISINSCOPE.

Last updated 3 November 2026 · OpenBI Studio 0.3.74