Running total across years not showing correctly

Soulbergen — Mon, 26 Jun 2023 08:05:42 GMT

I am trying to build a visual based on data from SAP with actuals on posting data. I have used running total measure to display a cumulative graph over time. However, it either shows non-cumulative or cumulative but not sorted by proper month/year.

I would like the graph to display cumulative actuals over time (months and years) based on a CJI3 report from SAP.

What am i doing wrong?

See pictures attached.

Thank you kindly

Re: Running total across years not showing correctly

devanshi — Mon, 26 Jun 2023 09:34:58 GMT

Just write ALL function instead of ALLSELECTED.

Cumulative Actuals = CALCULATE( SUM('Table'[Actuals]),
FILTER( ALL('Table'[DateColumn]), 'Table'[DateColumn] <= MAX('Table'[DateColumn]) ) )

topic Re: Running total across years not showing correctly in DAX Commands and Tips

Running total across years not showing correctly

Re: Running total across years not showing correctly