Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Cumulative sum with filter issue.

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,
Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.