Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
99 | |
86 | |
80 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |