How to Create a Dynamic Running Total in DAX That Responds to Slicers and Filters

Hi Anonymous ,

I get what you mean about the running total not updating correctly with slicers or filters, that’s a pretty common DAX headache. When you want a running total that’s fully dynamic and respects all the slicers and filters, you usually wanna avoid TOTALYTD unless it’s a simple date scenario.

Try using something like this instead (assuming you have a Date table connected properly):

Running Total = 
CALCULATE(
    SUM('YourTable'[YourValue]),
    FILTER(
        ALLSELECTED('YourTable'[DateColumn]),
        'YourTable'[DateColumn] <= MAX('YourTable'[DateColumn])
    )
)

This formula sums up your [YourValue] column up to the max date in the current filter context, which means it should respect whatever slicers or filters the user applies (date range, product, whatever). Just make sure your Date table is marked as a Date Table and relationships are set up correctly.

If you want to get even more flexible, swap 'YourTable'[DateColumn] with your actual date field and 'YourTable'[YourValue] with the field you want to total.

Let me know if you run into any issues or need a tweak for your specific scenario!

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
translation and formatting supported by AI

Hi Anonymous  - you can use the CALCULATE function along with FILTER and ALLSELECTED. 

eg: 

Running Total =
CALCULATE(
SUM('YourTable'[SalesAmount]), -- replace with your measure/column
FILTER(
ALLSELECTED('YourDateTable'[Date]), -- respects slicers
'YourDateTable'[Date] <= MAX('YourDateTable'[Date])
)
)

try the above logic and replace with your table as per model. Hope this helps.

Anonymous 

you can also try to use new visual calculation to get running total

https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-visual-calculations-overview?wt.mc_id=DP-MVP-5004616