Forum Discussion

Ashik786's avatar
Ashik786
Frequent Visitor
2 years ago

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.

 

Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    2 years ago

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