Help with running total with multiple filters

[forgetmenot]

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? 

[forgetmenot · Accepted solution]

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. 

[FreemanZ]

hi @forgetmenot ,

just post some sample data

[forgetmenot]