DAX Filter - ISFILTERED function

Description

Returns TRUE when columnName is being filtered directly.

If there is no filter on the column or if the filtering happens because a different column in the same table or in a related table is being filtered, then the DAX ISFILTERED function returns FALSE.

Syntax

ISFILTERED (<columnName>)

Parameters

Sr.No.	Term & Definition
1	columnName The name of a column in a table. It cannot be an expression.

Return Value

TRUE or FALSE.

Remarks

A column is said to be filtered directly when the filter or filters apply over the column.
A column columnName 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.

You can use DAX ISCROSSFILTERED function to find if a column is cross-filtered.

Example

= ISFILTERED (Sales[Product])

dax_functions_filter.htm