Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Ashik786
Frequent Visitor

Sub-Total for rows values and column in Matrix

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.

 

Screenshot_20231129_131157.jpg

3 REPLIES 3
amitchandak
Super User
Super User

@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])

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

@amitchandak  Item in row 

@Ashik786 , Try like

 

M1= Sumx(Summarize(Table, Table[Warehouse], Table[Location], Table[Item], "_1", [Cost Measure]), [_1])

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

Top Solution Authors