Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

Cumulative sum with condition

Hello This is my situation : Date Amount Condition Cumulative if Condition = Y 01-01-18 0 0 01-02-18 0 0 01-03-18 0 0 01-04-18 0 0 01-05-18 0 0 ...

Community Support

6 years ago

Hi,

Please try to create a calculated column first:

New Amount = IF('Table'[Condition]="N",0,'Table'[Amount])

Then try this measure:

Measure = CALCULATE(SUM('Table'[New Amount]),FILTER(ALLSELECTED('Table'),'Table'[Date]<=MAX('Table'[Date])))

The result shows:

Here is my test pbix file:

Hope this helps.

Best Regards,

Giotto