Forum Discussion

Chamara's avatar
Chamara
Advocate I
9 years ago
Solved

Cumulative sum with VALUES filter issue?

I want to show the Cumulative sum of positive numbers. I also want to have another Cumulative sum that adjusts with some slicers. I created 2 measures to do this. Cumulative Sum works fine. Hower my ...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi Chamara,

    Please use the following formula to create Cumulative Sum Filtered measure and check if you get expected result.

    Cumulative Sum Filtered = CALCULATE (
        SUM ( Data1[Revenue] ),
           FILTER(ALLEXCEPT(Data1,Data1[Classification]), Data1[TargetDate] <= MAX ( Data1[TargetDate])
    )
    )




    Thanks,
    Lydia Zhang

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Chamara,

Please use the following formula to create Cumulative Sum Filtered measure and check if you get expected result.

Cumulative Sum Filtered = CALCULATE (
    SUM ( Data1[Revenue] ),
       FILTER(ALLEXCEPT(Data1,Data1[Classification]), Data1[TargetDate] <= MAX ( Data1[TargetDate])
)
)




Thanks,
Lydia Zhang

Chamara's avatar
Chamara
Advocate I
9 years ago

AnonymousYour DAX actually give the data I need and I marked it as the answer. Thank you for that. However, I believe the formula I had initially for 'Cumulative Sum Filtered' should give the same results and that it is a bug. I do not discount the third possibility that I have not understood the DAX used in that. Either way, I would like to get closure on that as well and will log a bug in couple of days with that intention.