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.
AllisonKennedy
Community Champion
Community ChampionIs there any relationship between your Month table and Data table? If there is, it will only ever show the month that is selected, so you'll need to remove the relationship or create a series of measures that remove the filter.
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.
- AllisonKennedyYou 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 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!