topic Re: Cumulative Total in Matrix in DAX Commands and Tips

Cumulative Total in Matrix

RY2019 — Sun, 31 Oct 2021 16:42:45 GMT

Hi all,

does somebody know how I can adjust or cumulativ a secific column in a Matrix visualization ?

How I want to see it in my Power BI Report you can see it in the screenshot in green:

What Dax Formula I can take to get my cumulativ Total with rd. 9mio.

Thanks in Advance for any ideas :).

AlexisOlson — Sun, 31 Oct 2021 18:53:19 GMT

Just to be clear, you want a cumulative total of a cumulative total column?

RY2019 — Sun, 31 Oct 2021 18:56:40 GMT

Yes 🙂 I want a cumulative Total of this Cumulative Baseline. In this case the cumulative Total is rd. 9M and not the 1.7M.

Jihwan_Kim — Mon, 01 Nov 2021 03:45:43 GMT

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

All measures are in the attached pbix file.

Cumulative: =

SUMX (

VALUES ( Database[Stage] ),

CALCULATE (

SUM ( Database[Baseline] ),

FILTER ( ALL ( Database ), Database[Stage] <= MAX ( Database[Stage] ) )

)

Want to see: =

IF (

HASONEVALUE ( Database[Stage] ),

CALCULATE (

[Cumulative:],

FILTER ( ALL ( Database ), Database[Stage] <= MAX ( Database[Stage] ) )

)