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.
I'm facing a unique problem with sub-totals on Power BI Matrix Report. I've created a subtotal on one of the grouping column called "Subinventory". Also, on the same column, However, the matrix report is not displaying the sub-totals for Item.
I've been trying to resolve this issue for past one day and have looked all around the web and nothing seems to point me in the right direction. Can anyone please guide/help me in finding what's the issue here and the solution?
I'm facing a unique problem with sub-totals on Power BI Matrix Report. I've created a subtotal on one of the grouping column called "Subinventory". Now, the sub-total works fine when for values field. But I have put Item in row field so there's not showing subtotal for Item.
Please help me in this.
@Ashik786 , I doubt cost measure is using row context
Try a measure on top of it
M1= Sumx(Summarize(Table, Table[Warehouse], Table[Location], "_1", [Cost Measure]), [_1])
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
58 | |
45 | |
42 |