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.
Hi,
I want to create Non Additive Heirarchy Slicer.When user select Americas in Hierarchy slicer, then All value which is 200 should display in graph instead of Total 470.
Dataset
Date | Metric | Region | Country | Value |
2/1/2019 0:00 | EU | Americas | All | 200 |
2/1/2019 0:00 | EU | Americas | Canada | 100 |
2/1/2019 0:00 | EU | Americas | Mexico | 50 |
2/1/2019 0:00 | EU | Americas | US | 120 |
2/1/2019 0:00 | EU | Asia | All | 500 |
2/1/2019 0:00 | EU | Asia | China | 400 |
2/1/2019 0:00 | EU | Asia | India | 200 |
Solved! Go to Solution.
Hi @atul9063
You may create a measure like below:
Measure = IF ( HASONEVALUE ( Table3[Country] ), SUM ( Table3[Value] ), CALCULATE ( SUM ( Table3[Value] ), Table3[Country] = "ALL" ) )
Regards,
Cherie
Hi @atul9063
You may create a measure like below:
Measure = IF ( HASONEVALUE ( Table3[Country] ), SUM ( Table3[Value] ), CALCULATE ( SUM ( Table3[Value] ), Table3[Country] = "ALL" ) )
Regards,
Cherie
I have added two heirarchy slicer Client and UserType.As per above solution, its working fine for ClientType but not for UserType.For UserType is adding up values.Could you please check below DAX and let me know what i m doing wrong?
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 |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |