Forum Discussion
Filter data using selected value in slicer
Hello everyone! I have been trying to do something that seems simple but I cannot achieve it. I have a table that I use for a slicer and it allows the user to choose the month. The column Month...
- You can create a new measure for Value that removes the month filter and then reapplies based on how you want, so
VALUE = CALCULATE(SUM(table[value]), ALL(Month), DataMonth< Selected Month)
Pardon my terrible syntax, that's just meant to provide theory. Let me know if it doesn't make sense.
Thank you for your reply!
There is indeed a relationship between Data[Month] and Slicer[MonthValue]. However I need it for other visuals as well as in order to have the right values for each ID.
You can create a new measure for Value that removes the month filter and then reapplies based on how you want, so
VALUE = CALCULATE(SUM(table[value]), ALL(Month), DataMonth< Selected Month)
Pardon my terrible syntax, that's just meant to provide theory. Let me know if it doesn't make sense.
VALUE = CALCULATE(SUM(table[value]), ALL(Month), DataMonth< Selected Month)
Pardon my terrible syntax, that's just meant to provide theory. Let me know if it doesn't make sense.
Thank you for your help! That was what was missing! It works now 🙂
Hi Anonymous ，
Glad to know that your issue is solved,could you pls mark the reply as answered to close it?
Much appreciated.
Best Regards,
KellyDid I answer your question? Mark my post as a solution!