SQL Server
United States - English
Home
2012
2008 R2
2008
2005
2000
Library
Forums
This topic has not yet been rated - Rate this topic

HASONEFILTER Function (DAX)

Returns TRUE when the number of directly filtered values on columnName is one; otherwise returns FALSE.

Copy 
HASONEFILTER(<columnName>) 
columnName

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

TRUE when the number of directly filtered values on columnName is one; otherwise returns FALSE.

  1. An equivalent expression for HASONEFILTER() is COUNTROWS(FILTERS(<columnName>)) = 1.

  2. This function is similar to HASONEVALUE() with the difference that HASONEVALUE() works based on cross-filters while HASONEFILTER() works by a direct filter.

The following example shows how to use HASONEFILTER() to return the filter for ResellerSales_USD[ProductKey]) if there is one filter, or to return BLANK if there are no filters or more than one filter on ResellerSales_USD[ProductKey]).

Copy 
=IF(HASONEFILTER(ResellerSales_USD[ProductKey]),FILTERS(ResellerSales_USD[ProductKey]),BLANK())

Did you find this helpful?
(1500 characters remaining)
Community Content Add
Annotations FAQ