Forum Discussion
Bug - Hasonvalue - Matrix
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
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
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é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?
Thanks in advance!
