Forum Discussion
Create a filter based on a measure
I have a dataset with a lot of tickets. A tickets has an id, an open date, a start date and a close date. The end user has to possibility to select a single date and this will change the status ...
Create one dummy date table.
WHich is
Calendar=Calenderauto(01/01/2016,12/31/2020)
Create new measure
Filter = IF(MIN(Table2[ Open Date])<=MIN('Calendar'[Date]) && MIN(Table2[ Start Date])>=MIN('Calendar'[Date]),"Open",
IF(MIN(Table2[ Start Date])<=MIN('Calendar'[Date]) && MIN(Table2[ Close Date])>=MIN('Calendar'[Date]),"Started",
IF(MIN(Table2[ Close Date])<=MIN('Calendar'[Date]),"Closed")))
And add it in visual level filter.
from there you can set it to any value that is "Open","Started","Closed".
Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar
If I resolve your problem Mark it as a solution and give kudos.
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar
If I resolve your problem Mark it as a solution and give kudos.