Running sum and 0 (zero) values

Hi dantheram ,

For the example you mentioned I think it can be solved using the overlay method. I create a table as you mentioned.

Then I create a new measure to write the DAX code.

Measure =
VAR _currentKey =
    SELECTEDVALUE ( 'Table'[Key] )
VAR _previousKey =
    CALCULATE (
        MAX ( 'Table'[Key] ),
        FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Key] <= _currentKey )
    )
RETURN
    SUMX (
        FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Key] <= _previousKey ),
        'Table'[Value]
    )

Finally we will get what we want.

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.