Cumulative sum with filter issue.

[Anonymous]

Hi,

I am using this formula to get cumulative value, but it stopps working once applied slicer. Can you please help me to change it?

CUMULATIVE MISSED = Calculate([SUMofMISSED],Filter(All('Stockfill Data'[Material],'Stockfill Data'[Material Number],'Stockfill Data'[ABC]),sum('Stockfill Data'[MISSED])<=[SUMofMISSED]))

Thank you in advance,

[Anonymous]

Hi @Anonymous ,

I'm sorry because you didn't provide sample data, and I can't give you a completely correct answer.
However, if you want your measure to be independent of the slicer, a common option is to use the "ALLSELECTED" function. This function returns all values in the column, including those that are not selected in the slicer. For more information on how to use this function, you can refer to the following documentation:
ALLSELECTED function (DAX) - DAX | Microsoft Learn
If you'd like to provide sample data, I'd be happy to try to figure it out for you! But be careful not to include privacy in the sample data.

Best Regards,

Dino Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.