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.
Anonymous , I am hoping both tables are joined. It is a number use less than equal to option in the slicer. With small down arrow in slicer you have that option