ISFILTERED DAX Function (Information)
Returns true when there are direct filters on the specified column.
Syntax
| Parameter | Attributes | Description |
|---|---|---|
| TableNameOrColumnName |
The table or column to check the filter info. |
Return values
TRUE when ColumnName is being filtered directly, or when any column of TableName is being filtered directly.
Remarks
A column is said to be filtered directly when the filter or filters apply over the column.
A column or table is said to be cross-filtered when a filter is applied to any column of the same table or in a related table.
ISFILTERED can check whether a column is being filtered directly or if any of the columns of the table is being filtered directly.
ISFILTERED supports a table argument since SSAS 2019 or Power BI April 2019. Former versions only support the column name argument.
Examples
-- These queries return FALSE
EVALUATE { CALCULATE ( ISFILTERED ( Sales ), 'Product'[Color] = "Red" ) }
EVALUATE { CALCULATE ( ISFILTERED ( Sales[Quantity] ), 'Product'[Color] = "Red" ) }
EVALUATE { CALCULATE ( ISFILTERED ( Sales[Quantity] ), Sales[Unit Price] > 10 ) }
--These queries return TRUE
EVALUATE { CALCULATE ( ISFILTERED ( Sales ), Sales[Unit Price] > 10 ) }
EVALUATE { CALCULATE ( ISFILTERED ( Sales[Unit Price] ), Sales[Unit Price] > 10 ) }
Related functions
Other related functions are:
Last update: Aug 1, 2020 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
MSDN documentation: https://docs.microsoft.com/en-us/dax/isfiltered-function-dax