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 repor...
Need Help
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])

  • amitchandak's avatar
    amitchandak
    Super User
    2 years ago

    Ashik786 , Try like

     

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