Cumulative Total in Matrix

[RY2019]

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

[Jihwan_Kim · Accepted solution]

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 (

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

)

)

[AlexisOlson]

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

[RY2019]

@AlexisOlson 

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