Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I have this data:
Item Number | Site | Warehouse | Location | Inventory Physical |
1 | A | ABC | 11 | 10 |
1 | A | DFG | 12 | 50 |
1 | A | PTN | 15 | 100 |
1 | B | FF | 22 | 150 |
1 | B | GG | 25 | 200 |
And I am trying to figure out how I can have a matrix with the rows in the following order: Item Number > Site > Warehouse > Location, and then Inventory Physical in the values with stepped layout off.
Where it gets tricky is I only want to see the sum of inventory physical for the item number level, I don't want to see totals for site, warehouse, or location. I have went through all of the matrix settings and can't figure out how to achieve this.
Solved! Go to Solution.
Hi @CC25 ,
You can try below formula and turn off stepped layout icon.
TotalInventoryPhysical =
SUM('Table'[Inventory Physical])
DisplayInventoryPhysical =
IF(
ISINSCOPE('Table'[Item Number]),
[TotalInventoryPhysical],
BLANK()
)
Best Regards,
Adamk Kong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @CC25 ,
You can try below formula and turn off stepped layout icon.
TotalInventoryPhysical =
SUM('Table'[Inventory Physical])
DisplayInventoryPhysical =
IF(
ISINSCOPE('Table'[Item Number]),
[TotalInventoryPhysical],
BLANK()
)
Best Regards,
Adamk Kong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
In the matrix settings, under Row subtotals, you can switch on 'Per row level' and that will let you select which levels get a sub total.
You would select the rows you want to disable it on in the 'Row level' dropdown then turn off 'Show Subtotal'
When I turn off subtotal for all rows except item number, it doesn't work correctly, it is still somehow managing to sum by the last row, "Location".
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
109 | |
98 | |
96 | |
38 | |
36 |
User | Count |
---|---|
151 | |
125 | |
75 | |
74 | |
53 |