FILTERS is a DAX function that returns the current filter values applied directly to a specified column.
FILTERS( ColumnName )| Argument | Properties | Description |
|---|---|---|
| ColumnName | The column for which filter values are to be returned. |
The values that are directly applied as filters to columnName.
This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.
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.
2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy