HASONEVALUE returning false although only 1 distinct value.

Question

Good day my fellow dax experts,Can someone help me to understand how HASONEVALUE works. From the documentation of the function"TRUE&nbsp;when the context for&nbsp;columnName&nbsp;has been filtered down to one distinct value only. Otherwise is&nbsp;FALSE".&nbsp;However, it returns FALSE when i run it on the Contoso Data. May i know why this is happening? As A.Datum or Adventure works should only have 1 distinct value in their respective table, hence it should return TRUE.&nbsp;RegardsAdrian&nbsp;&nbsp;

amitchandak · Answer

Anonymous , Refer if this from SQLBI, can help
https://www.youtube.com/watch?v=JZRKRW-aK7c

marcin82 · Answer

Great question. But of course - no real answer here.&nbsp;

marcin82 · Answer

Congrts on posting useless link. This is not the answer

anonymous · Answer

I have the same question, could anyone know why?

anonymous · Answer

After I changed it to single direction, problem resolved.

Forum Discussion

HASONEVALUE returning false although only 1 distinct value.

5 Replies

Related content

HASONEVALUE problem

Using IF(HASONEVALUE() returning incorrect (and SLOW) results

hasonevalue

HASONEVALUE alternatives?

HASONEVALUE return false despite of distinct value