Forum Discussion
Solved
Advanced filtering slicer
Hey! I have a sliding slicer where you can select a range of dates you want to see the visuals in. I am trying to make another visual (a table) that shows how many tickets were open during a specific...
Hi,
Here is one way to do this:
Data:
Relationships:Calendar and table 33 don't have any relationship
Dax:Filter based on max date = var _mdate = MAX('Calendar'[Date]) return
IF(MAX('Table (33)'[Date])>=_mdate,1,0)
Place the measure like this:
Now since the range has 9.9.2023 selected only the last two values are shown.
When another date is selected the values change:
ValtteriN
Community Champion
Community ChampionHi,
Here is one way to do this:
Data:
Relationships:
Calendar and table 33 don't have any relationship
Dax:
Filter based on max date = var _mdate = MAX('Calendar'[Date]) return
IF(MAX('Table (33)'[Date])>=_mdate,1,0)
Place the measure like this:
Now since the range has 9.9.2023 selected only the last two values are shown.
When another date is selected the values change: