topic Re: Dynamic filter depending on another filter in DAX Commands and Tips

Dynamic filter depending on another filter

LotteLaugesen — Thu, 28 Apr 2022 13:25:00 GMT

I would like to have a date filter showing the last 7 or 14 days depending on another filter like this:

Is it possible?

Lotte

Re: Dynamic filter depending on another filter

amitchandak — Thu, 28 Apr 2022 13:51:58 GMT

LotteLaugesen , Create a measure

countrows(filter('Date', Date[Date] <= Today() && Date[Date] >= Today() - (selectedvalue(Table[Number])*7) ))

and check the values is not blank in the visual level filter of the slicer

Re: Dynamic filter depending on another filter

LotteLaugesen — Fri, 29 Apr 2022 08:11:11 GMT

Hi amitchandak

It doesn't seem to work - it doesn't matter if I select 1 or 2 week the measure is 1.
If it worked how could I then use it as a filter for the date slicer?

Re: Dynamic filter depending on another filter

LotteLaugesen — Fri, 29 Apr 2022 12:36:45 GMT

I have find a way to solve it 🙂

Include Date = IF(SELECTEDVALUE(Weeks[Weeks]) = 1 && SELECTEDVALUE(Dim_Calendar[IndexDay]) < 7,1,IF(SELECTEDVALUE(Weeks[Weeks]) = 2 && SELECTEDVALUE(Dim_Calendar[IndexDay]) < 14,1,0))

Where IndexDay is days from today
and then I just put a filter on Date slicer saying that Include Date should be 1