Forum Discussion

MrMP's avatar
MrMP
Helper III
3 years ago
Solved

Cumulative showing wrong figures

Hi everyone!   I am facing problems with cumulative calculations. Ive tried multiple formulas from the internet, quick measure. Nothing seems to fix the trick. As showed below, I need to have cumul...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    MrMP , Try like 

    Calc 7(cumulative of calc6) = CALCULATE(sumx(SUMMARIZE(Input,'Calendar'[Year],'Calendar'[Quarter]),[Calc 6]), filter(all('Calendar'), [Date]
 <=max('Calendar'[Date])))
//cumulative

or

Calc 7(cumulative of calc6) = CALCULATE(sumx(SUMMARIZE(Input,'Calendar'[Year],'Calendar'[Quarter]),[Calc 6]), filter(allselected('Calendar'), [Date]
 <=max('Calendar'[Date])))
//cumulative
amitchandak's avatar
amitchandak
Super User
3 years ago

MrMP , Try like 

Calc 7(cumulative of calc6) = CALCULATE(sumx(SUMMARIZE(Input,'Calendar'[Year],'Calendar'[Quarter]),[Calc 6]), filter(all('Calendar'), [Date]
 <=max('Calendar'[Date])))
//cumulative

or

Calc 7(cumulative of calc6) = CALCULATE(sumx(SUMMARIZE(Input,'Calendar'[Year],'Calendar'[Quarter]),[Calc 6]), filter(allselected('Calendar'), [Date]
 <=max('Calendar'[Date])))
//cumulative