Advanced filtering slicer

[gracehutchinson]

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 time frame. I was thinking about using advanced filter settings on the table, such as only counting those in which the closing date is greater than that of the maximum slicer value, however the advanced settings only allows for a manual input. If anyone knows how to help/has any ideas that would be greatly appreciated 🙂

[ValtteriN · Accepted solution]

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: