How to drill-through a date (from Calendar) and show all lines that have this date on various column

[gluizqueiroz]

I have 2 tables, named Table_Tickets and Dim_Calendar, like the following:

I have created a chart, like the following:

When I drill-through a date (for example, 2020-11-05) in this chart, the page just show me the Id_Ticket = 2, because this ticket was created in "2020-11-05", but this is not right to my case, I need the page show me Id_Ticket = 1 and 2, because ticket 1 was closed (and resolved too) in "2020-11-05" and ticket 2 was created in "2020-11-05", in other words, when I drill a date, I need to see all the tickets with "action" in this date, all the tickets that was created in this date OR was closed in this date OR was resolved in this date, not just created.

Someone know how I achive this?

[amitchandak]

@gluizqueiroz , Refer my HR Blog - https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

or between dates blog

https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-o...

[gluizqueiroz · Accepted solution]

Hey @amitchandak, using your ideia I have changing my model to 3 relationships deactivated and created this measure:

Ind_ShowOrHide = 
VAR DaySelec = SELECTEDVALUE(Dim_Calendar[Date])
VAR Create = SELECTEDVALUE(Table_Tickets[Date_Creation])
VAR Closed = SELECTEDVALUE(Table_Tickets[Date_Closed])
VAR Resolved = SELECTEDVALUE(Table_Tickets[Date_Resolved])
RETURN
IF(Create= DaySelec || Closed = DaySelec || Resolved = DaySelec ,
    1,
    0
)

 And I put this measure on my table and made a permanent filter to Ind_ShowOrHide = 1 and it worked.

Thanks for helping.