Edit

Share via

FILTERS

  • Article

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.