Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
forgetmenot
Helper I
Helper I

Help with running total with multiple filters

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? 

1 ACCEPTED SOLUTION
forgetmenot
Helper I
Helper I

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. 

View solution in original post

3 REPLIES 3
forgetmenot
Helper I
Helper I

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
Super User
Super User

hi @forgetmenot ,

 

just post some sample data

forgetmenot_0-1701000077621.png

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.