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.
Athugasemdir
https://aka.ms/ContentUserFeedback.
Væntanlegt: Á árinu 2024 munum við hætta með GitHub-mál sem ábendingaleið fyrir efni og skipta því út fyrir nýtt ábendingakerfi. Frekari upplýsingar er að finna hér:Senda inn og skoða endurgjöf fyrir