Multiple grand totals on matrix

[ReutAtias12]

Hi, I'm trying to add 2 totals to a matrix 

I want it to be something like this: 

**the value inside the matrix is counted for each step base on the categories (reason)

** the new total is based on a measure and it sums the money, I don't want the value to appear in the rows 

I only want to add the total sum of this measure under the grand total (under the count total)

reason/steps	step1	step2	step3	step4	step5
aa	30	20	10	5	1
baaa	45	25	25	12	8
csd	10	0	0	0	0
total	85	45	35	17	9
new total	1555$	4845$	110$	155$	151$

[tamerj1 · Accepted solution]

Hi @ReutAtias12 

You can create a disconnected table that contains all reasons + "Total" let's call it 'SlicerReason'. Then you can place SlicerReaon[Reson] in the rows of the matrix and the following measure in values of the matrix

 ResultMeasure =
IF (
HASONEVALUE ( ReasonSlicer[Reason] ),
SUMX (
VALUES ( ReasonSlicer[Reason] ),
IF (
ReasonSlicer[Reason] = "Total",
[CountMeasure],
CALCULATE ( [CountMeasure], 'Table'[Reason] = ReasonSlicer[Reason] )
)
),
[MoneySumMeasure]
)

[ReutAtias12]

Thanks! 

[Greg_Deckler]

@ReutAtias12 You could potentially adapt this approach. The New Hotness (Custom Matrix Hierarchy) - Microsoft Power BI Community

Another potentially approach would be Deneb