Forum Discussion

tiny's avatar
tiny
Frequent Visitor
2 years ago
Solved

Filter table dynamically based on multiple selections from a Slicer

Hello, I'm trying to filter table dynamically based on multiple selections from a Slicer. Here is an example, I have a date table and is used as slicer, the slicer is with a hierarchy  (Year->Month-...
  • wdx223_Daniel's avatar
    wdx223_Daniel
    2 years ago

    CALCULATE(SUM(Sales[Sales]),TREATAS(VALUES(DateTable[Date YM]),Sales[Date YM]))

tiny's avatar
tiny
Frequent Visitor
2 years ago

Perfect! Works great 🙂 Thank you very much! Really appreciated!