topic Multiple grand totals on matrix in DAX Commands and Tips

Multiple grand totals on matrix

ReutAtias12 — Tue, 14 Feb 2023 15:51:17 GMT

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$

Re: Multiple grand totals on matrix

Greg_Deckler — Tue, 14 Feb 2023 16:12:22 GMT

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

Another potentially approach would be Deneb

Re: Multiple grand totals on matrix

tamerj1 — Tue, 14 Feb 2023 16:30:46 GMT

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

Re: Multiple grand totals on matrix

ReutAtias12 — Tue, 14 Feb 2023 16:49:46 GMT

Thanks!