ISCROSSFILTERED
Returns TRUE when the specified table or column is cross-filtered.
Syntax
ISCROSSFILTERED(<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 cross-filtered. Otherwise returns FALSE.
Remarks
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.
A column or table is said to be filtered directly when a filter is applied to ColumnName or to any column of TableName. Therefore, the ISFILTERED function also returns TRUE when ColumnName or any column of TableName 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
ISFILTERED function
FILTERS function
HASONEFILTER function
HASONEVALUE function
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for