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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hey, I am new to power BI and I have some query related to the same topic. Can I put cumulative sum based on dates in a number card and then filter it for specific dates using a date slicer. I am currently using Datesmtd dax as i only want to calculate cumulative sum month by month.