topic Re: Help with running total with multiple filters in DAX Commands and Tips

Help with running total with multiple filters

forgetmenot — Sat, 25 Nov 2023 09:38:17 GMT

Hi guys,

Im hoping somone can help me.

I currently have the following measure :

CM 2022-23 (Ton) =

CALCULATE(

SUM('Table_ALL'[Tonnage]),

'Table_ALL'[FY] IN { "2022 23" } &&

'Table_ALL'[Type] IN {"Co-mingled"}

)

I need to amend this to a running total. I am unsure how to do this since I have multiple criteria.
For example I am currently bringing back the Tonnage of co-mingled waste from the FY 2022-23, The client wants a line per waste type to be plotted per year, however the ask is thats its plotted on one axis so lines appear above and below it I have done this by putting month on x-axis as a text so can see trends for same months in previous years.

Can someone please assist?

Re: Help with running total with multiple filters

FreemanZ — Sat, 25 Nov 2023 15:31:28 GMT

hi forgetmenot ,

just post some sample data

Re: Help with running total with multiple filters

forgetmenot — Sun, 26 Nov 2023 12:01:26 GMT

Re: Help with running total with multiple filters

forgetmenot — Mon, 27 Nov 2023 11:00:04 GMT

HI guys,

Managed to find a solution for this where I duplictated the original table, created groups per category and calculated running total as a function.

following this I amended my orginal Dax measure to reference newly created table and now have running totals per group and FY as per clients request.