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

dkay84_PowerBI's avatar
dkay84_PowerBI
Microsoft Employee
9 years ago

I will take a look at helping you with your filtered cumulative sum measure, but PLEASE tell me how you were able to attach a file to your post?  I've always had to add a link to a shared drive for files.

Chamara's avatar
Chamara
Advocate I
9 years ago

dkay84_PowerBI,Re: Attaching files: It works on FireFox and not IE. In Firefox I get an option at the bottom to attach files even for replies.