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
Community SupportHello Royston,
We hope you're doing well. Could you please confirm whether your issue has been resolved or if you're still facing challenges? Your update will be valuable to the community and may assist others with similar concerns.
Thank you.
Hi Ganesh,
Thanks for the follow up, I missed this message as I was on my break. The graph you produced was not what I was looking for, unfortunately.
I was hoping to have the red line remain static regardless of what hour filter was chosen. So for example, assuming hour 4's value is 50 but the cumulative value is 1000 when counted from 0, I'd like the graph to start at 1000 when i select the hour 4 on the slicer instead of 50.
Does that make sense?
Thanks.
Best,
Roy
- v-ssriganesh
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 SingamshettyHi 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
- v-ssriganesh
Hello 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.