Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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é
Solved! Go to 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
@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
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!
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é
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
97 | |
80 | |
67 | |
63 |
User | Count |
---|---|
147 | |
110 | |
108 | |
85 | |
64 |