Bug - Hasonvalue - Matrix

[Anonymous]

Dear All, 

I think I found a bug regarding the "HASONVALUE" calculation, so when there is only one element in a list, the hasonvalue can't work in a proper way. 

Could you please advise? 

Thank you so much, 

Máté

[OwenAuger · Accepted solution]

@Anonymous 

For what you're trying to do, since in the context of the matrix there is only one country within Arab States, HASONEVALUE ( Sheet1[Country] ) returns TRUE for both the Region and Country level.

You can use the ISINSCOPE function instead of HASONEVALUE and you should only see values at the country "level".

By the way, would you want to consider aggregating with SUM instead of SELECTEDVALUE? SELECTEDVALUE will return either the single value in the Summa column or blank if there are multiple values.

Regards,

Owen

[analytics_ISFC]

Hi Owen,

I also have a similar problem. 

this is the link to the problem. I tried your solution but it didnt help. Could you help me resolving this?

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Calculation-change-with-drill-down/m-p/994791...

Thanks in advance!

[Anonymous]

Dear Owen, 

This is why I love this community, it is a pleasure to work with clever people! 

Thank you for your recommendations, they helped me a lot.

All the best, 

Máté