Forum Discussion

Anonymous's avatar
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 ...
Need Help
  • v-gizhi-msft's avatar
    v-gizhi-msft
    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:

    pbix 

    Hope this helps.

     

    Best Regards,

    Giotto

camargos88's avatar
camargos88
Community Champion
6 years ago

Hi Anonymous ,

 

Try creating this measure:

 

Running Total = CALCULATE(SUM('Table'[Amount]); FILTER(ALL('Table'[Date]); 'Table'[Date] <= MAX('Table'[Date])); 'Table'[Condition] = "Y")
 
Ricardo
Anonymous's avatar
Anonymous
Not applicable
6 years ago

camargos88  : i forgot the @...