Running totals measure without blanks

[Riggan2023]

Hi.

I need help with running total measure. I cant figure out how to fill the blanks in my running total calculations.  I dont need blanks. They should be filled by previous value if the appropriate cell is eq. 0

This is how it should look like

I use this measure to calculate Running totals

RunningTotal = CALCULATE(
COUNT('Dataset'[ArchDate]),
FILTER(  ALLSELECTED('Dataset') ,
SUMX( FILTER( 'Dataset', EARLIER( 'Dataset'[ArchDate] ) <= 'Dataset'[ArchDate] ), COUNT('Dataset'[ArchDate] ))
))

This is my sample pbix

https://file.io/mdWjHkb9oHuB 

[AlexisOlson · Accepted solution]

That's a pretty odd measure with a SUMX being used as a boolean filter inside FILTER.

Try something simpler like this:

RunningTotal =
VAR CurrDate = MAX ( MyCalendar[Date] )
RETURN
    CALCULATE (
        [Totals],
        ALLSELECTED ( MyCalendar ),
        MyCalendar[Date] <= CurrDate
    )