Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello all,
I am Trying to sum the values at Hierarchy (Product A = Material A +Material B+ Material C) where as (Material A = 10) which inturn is the summed value.( Material A= Element 1+ Element2+ Element3). Total is the sum of values across product A (Total = Area1 +Area2 +Area3+..). How to show this calculation in Matrix Visualization.
Thanks for your help,
Shashi
Product\Location | Area1 | Area2 | Area3 | Area4 | Total | ||
Product A | 40 | 10 | 0 | 40 | 90 | ||
MaterialA | 10 | 0 | 0 | 10 | 20 | ||
Element1 | 5 | 0 | 0 | 0 | 5 | ||
ELement2 | 5 | 0 | 0 | 0 | 5 | ||
Element3 | 0 | 0 | 0 | 10 | 10 | ||
MaterialB | 20 | 10 | 0 | 20 | 50 | ||
MaterialC | 10 | 0 | 0 | 10 | 20 | ||
Product B | 30 | 30 | 10 | 0 | 70 | ||
MaterialD | 10 | 10 | 0 | 0 | 20 | ||
MaterialE | 20 | 20 | 10 | 0 | 50 |
That should be standard matrix functionality. You get the level specific row totals and grand totals for free.
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
30 | |
13 | |
11 | |
9 | |
6 |