Forum Discussion

H_Jones's avatar
H_Jones
Icon for Helper I rankHelper I
8 years ago

cumulative sum issues when filtering

I am having some issues with my cumulative sum. I initially thought it was working fine, until I added a date slicer onto the page and now when that is used the sum goes bonkers, I dont even understa...
Need Help
MFelix's avatar
MFelix
Icon for Super User rankSuper User
8 years ago

Hi H_Jones,

 

When using the ALL function on your measure what happens is that the calculations are made based on the total table values and overlaps the filter you have in your visuals so the values it gets return is based on the full table and not on the context.

 

If you want to add a slicer try to change your formula to:

 

Cumulative Pledges =
CALCULATE (
    [Pledges],
    FILTER (
        ALLSELECTED ( 'Attrition Data'[Attrition Flag] ),
        'Attrition Data'[Attrition Flag] <= MAX ( 'Attrition Data'[Attrition Flag] )
    )
)

 

Regards,

MFelix

H_Jones's avatar
H_Jones
Icon for Helper I rankHelper I
8 years ago

It hasnt changed the values at all unfortunately.