Table of contents
TOC
Collapse the table of content
Expand the table of content

FILTERS Function (DAX)

Owen Duncan|Last Updated: 10/5/2018
|
1 Contributor

Returns the values that are directly applied as filters to columnName.

Syntax

FILTERS(<columnName>)  

Parameters

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

Example

The following example shows how to determine the number of direct filters a column has.

=COUNTROWS(FILTERS(ResellerSales_USD[ProductKey]))  

The example above lets you know how many direct filters on ResellerSales_USD[ProductKey] have been applied to the context where the expression is being evaluated.

© 2018 Microsoft