Export (0) Print
Expand All
0 out of 6 rated this helpful - Rate this topic

FILTERS Function (DAX)

SQL Server 2012

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

FILTERS(<columnName>)

columnName

The name of an existing column, using standard DAX syntax. It cannot be an expression.

The values that are directly applied as filters to columnName.

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.