Forum Discussion
Calculating Totals inside a Matrix
Hi, I have a Matrix with two levels of rows. The subtotals summarize the first row-level and the Grand Total summarizes the subtotals. I wonder if there is a way to create Totals of the s...
Hi Greg_Deckler ,
thank you for your answer and sorry for the confusion.
Since I'm not sure how to present my problem with actual data, I've created an Excel template which you can see below.
I just basically want Power BI to calculate the totals from a given Matrix and show the result in that matrix.
Kind regards
Try to create a measure like below:
Measure =
CALCULATE(SUM('Table'[Values]),ALLEXCEPT('Table','Table'[Level2]))
Hi V-lianl-msft ,
this looks pretty good, thx. But is there a way to show the measure in rows below the given data instead of showing it in a new column?
Kind regards
Unlikely, unless you rebuild the table model.