ISFILTERED

ISFILTERED is a DAX function that returns TRUE when there are direct filters on the specified column.

Syntax

ISFILTERED( TableNameOrColumnName )

Argument	Properties	Description
TableNameOrColumnName		The table or column to check the filter info.

Return Values

TRUE when ColumnName or a column of TableName is being filtered directly. Otherwise returns FALSE.

Remarks

• A column or table is said to be filtered directly when a filter is applied to ColumnName or any column of TableName.

• A column or table is said to be cross-filtered when a filter is applied to ColumnName, any column of TableName, or to any column of a related table. Therefore, the ISCROSSFILTERED function also returns TRUE when ColumnName, any column of TableName, or a column of a related table is filtered.

• This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.

Empty

Related functions

Other functions related to ISFILTERED are:

• HASONEFILTER
• HASONEVALUE
• ISCROSSFILTERED
• ISINSCOPE
• ISSUBTOTAL

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/dax/isfiltered-function-dax