Conditional Running Total (cumulative total)

[Anonymous]

Hi Everyone,
I have stuck at this point of time due to this issue. I have searched everywhere but did not find the solution which I required. Below is a table which I need to create in Power BI.

I know how to calculate Running Total but here the requirement is that for a particular row if Amount is 0 then Running Total should be 0.

Any help would be greatly appreciated.

[Mariusz]

Hi @Anonymous 

Try this Measure

Measure = 
VAR _MaxDate = CALCULATE( MAX( 'Table'[Date] ), 'Table'[Amount] > 0 )
RETURN 
CALCULATE(
    SUM( 'Table'[Amount] ),
    ALL( 'Table' ),
    'Table'[Date] <= _MaxDate
) + 0

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.