Forum Discussion

RDF25087's avatar
RDF25087
Helper I
3 years ago

Cummulative Sum ignoring slicer

Hi all -

 

This is probably simple but I'm struggling...

 

I have a measure that counts the number of claims for 2023 by sales rep:

 

2023 Claimed Qty =
CALCULATE(
SUM('Sales Report (Claims)'[Claimback Qty]),
FILTER('Sales Report (Claims)','Sales Report (Claims)'[Invoice Year] = 2023),
FILTER('Sales Report (Claims)','Sales Report (Claims)'[Invoice Month 2] = SELECTEDVALUE('Calendar'[MonthNum])) )
 
The chart I have then created shows the claimed quantity depending on which month is selected on the slicer.
 
However, what I'd like is a measure that gives a cummulative value based on the month claimed. So...
 
If Bob Smith had 180 claims in January and 150 claims in February...
 
When the user selects January the chart will show 180 for Bob. But if they select February it will show 330 for Bob (180 + 150)
 
Does that make sense?
 
Any help greatly appreciated.
 
RDF
Need Help