DAX Filter - HASONEFILTER function

Description

Returns TRUE when the number of directly filtered values on columnName is one and only one. Otherwise, returns FALSE.

Syntax

HASONEFILTER (<columnName>) 

Parameters

Return Value

TRUE or FALSE.

Remarks

DAX HASONEFILTER function is similar to DAX HASONEVALUE function, with the difference that HASONEFILTER works by a direct filter, while HASONEVALUE works based on crossfilters.

Example

= HASONEFILTER (Sales[Product])