HASONEVALUE returning false although only 1 distinct value.

[Anonymous]

Good day my fellow dax experts,

Can someone help me to understand how HASONEVALUE works. From the documentation of the function

"TRUE when the context for columnName has been filtered down to one distinct value only. Otherwise is FALSE". 


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. 

Regards

Adrian

[Anonymous]

After I changed it to single direction, problem resolved.

[Anonymous]

I have the same question, could anyone know why?

[Marcin82]

Great question. But of course - no real answer here. 

[amitchandak]

@Anonymous , Refer if this from SQLBI, can help

https://www.youtube.com/watch?v=JZRKRW-aK7c

[Marcin82]

Congrts on posting useless link. This is not the answer