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...
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.