Sub-Total for rows values and column in Matrix

[Ashik786]

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.

[amitchandak]

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

[Ashik786]

@amitchandak  Item in row 

[amitchandak]

@Ashik786 , Try like

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