DAX Function Guide

HASONEVALUE
Empty image or helper icon

Sam McKay

CEO & Founder

How does the HASONEVALUE work?
Returns TRUE if only one distinct value has been filtered to the context for columnName. Otherwise, it is FALSE.
HASONEVALUE Formula Syntax
HASONEVALUE(<columnName>)
How do you use the HASONEVALUE?

An equivalent expression for HASONEVALUE() is COUNTROWS(VALUES(<columnName>)) = 1.

Related Blog Posts

Loading

Considerations when using the HASONEVALUE?

HASONEVALUE() allows you to identify if your expression is being evaluated in the context of a single value for columnName.

Related Video Tutorials

Loading

Formula examples using the HASONEVALUE
=IF(HASONEVALUE(DateTime[CalendarYear]),SUM(ResellerSales_USD[SalesAmount_USD])/CALCULATE(SUM(ResellerSales_USD[SalesAmount_USD]),DateTime[CalendarYear]=2007),BLANK()) 
Related Courses

Loading