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