FILTERS
Returns the values that are directly applied as filters to columnName.
Syntax
FILTERS(<columnName>)
Parameters
| Term | Description |
|---|---|
| columnName | The name of an existing column, using standard DAX syntax. It cannot be an expression. |
Return value
The values that are directly applied as filters to columnName.
Remarks
This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.
Example
The following example shows how to determine the number of direct filters a column has.
= COUNTROWS(FILTERS(ResellerSales_USD[ProductKey]))
This example lets you know how many direct filters on ResellerSales_USD[ProductKey] have been applied to the context where the expression is being evaluated.
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