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 All,
I have a Employee Hierarchy upto Level 5. when i drill down to lewest level, i should see same grand total of first level parent.
Using calculate(sum(sales), All(Level2)) etc is not overwriting context instead of it is showing values within context of level2,3,4
Any Ideas
Solved! Go to Solution.
No. it worked by saying all in all levels of hierarchy.
Hi @rajendrav2016,
Can you mark the proper answer as a solution please?
Best Regards,
Dale
Hi @rajendrav2016,
The Matrix visual did have a subtotals. Is it what you would like?
Best Regards,
Dale
No. it worked by saying all in all levels of hierarchy.
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 |
---|---|
110 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |