FILTERS
Applies to:
Calculated column
Calculated table
Measure
Visual calculation
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
https://aka.ms/ContentUserFeedback.
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați:Trimiteți și vizualizați feedback pentru