Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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 |
---|---|
20 | |
18 | |
17 | |
11 | |
7 |
User | Count |
---|---|
29 | |
28 | |
13 | |
12 | |
12 |