Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
Calculated column
Calculated table
Measure
Visual calculation
Returns TRUE when the specified table or column is being filtered directly.
Syntax
ISFILTERED(<TableNameOrColumnName>)
Parameters
| Term | Definition |
|---|---|
TableNameOrColumnName |
The name of an existing table or column. It cannot be an expression. |
Return value
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
ColumnNameor any column ofTableName.A column or table is said to be cross-filtered when a filter is applied to
ColumnName, any column ofTableName, or to any column of a related table. Therefore, the ISCROSSFILTERED function also returnsTRUEwhenColumnName, any column ofTableName, 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.
Related content
ISCROSSFILTERED function FILTERS function HASONEFILTER function HASONEVALUE function