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
thakks's avatar
thakks
Icon for Helper I rankHelper I
8 years ago

Try this one

 

=CALCULATE (
[Pledges],
FILTER(ALLSELECTED(Sheet1), Sheet1[Attrition Flag]<= MAX ( Sheet1[Attrition Flag] ) ),
VALUES ( Sheet1[Channel] )
)

 

Key here is ALLSSELECTED & Values()

ALLSELECTED  will pass the Attrition Flag and Signup Date Filter or any filter selected in to the running total context

VALUES (Channel) will pass the channel context else it will have the running total on Attrition flag, with all having the same value.

 

 

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

Hey thakks, Thansk, This seems to get me almost there is not quite right but its very close, could you explain a little more what difference this makes so i can try and figure out why it isnt 100% accurate?

 

For your interest, its just right at the very end now that it start to tail of the actual value:

 

 

Thanks for your help!

H