Forum Discussion
Cumulative total all ignore specific filter help
Hello Royston,
Thank you for clarifying your requirement further. I have updated the .pbix file to ensure the red cumulative line remains static, regardless of the hour selected in the slicer.
For example, with your sample data:
- When only Hour 3 is selected, the blue cumulative shows 288 (local to filter), but the red cumulative shows 1044 (total up to Hour 3, ignoring the slicer).
- When only Hour 4 is selected, the blue cumulative shows 289, and the red cumulative correctly shows 1333.
This matches your expectation that the red line continues from the prior cumulative value rather than restarting at the slicer.
I am attaching the updated .pbix file for your reference so you can test it with your own data.
Best regards,
Ganesh Singamshetty
Hi Ganesh,
Thank you very much, it worked!
Can you explain how it works please? I understand it is based on the row filter context but i'm still trying to wrap my head around it. My Method 1 looks very similar to your code but i'm wondering what's different?
Thank you.
Best,
Roy
Community SupportHello Royston.
Glad it worked. The key difference is in how the filter context is handled:
- In your version, the slicer on End At Hour (Local) limited the calculation, so when you picked Hour 4, only that row (289) was visible.
- In my version, I used ALL('Table'[End At Hour (Local)]) to ignore the slicer, then reapplied a filter with
- 'Table'[End At Hour (Local)] <= MAX ( 'Table'[End At Hour (Local)] )
This way, the measure always sums from 0 selected hour, even if the slicer shows only one.
Best regards,
Ganesh Singamshetty.