Help using multiple date relationships

[CoboleiroBr]

Hello guys!

I have a Calendar table and a Tickets Table. 

The most important columns in Tickets Table are:

- Ticket Number

- Open Date

- Response Date

- Close Date

They are related with Calendar table by Open Date (active relationship), Response Date (inactive), Close Date (inactive).

I have a report and I need to filter the Tickets by Open Date. I use the Calendar Date in the slicer and it's working perfectly.

But how to use the Calendar date in the slicer to filter by Response Date? Is that possible?

I guess it's not possible, so I created a table called Responsed Tickets, filtering only the Tickets that were already responded. The problem is I can't create a relationship with Calendar Date, because another column in Tickets table is using a RELATED dax statement with calendar (to know if it's a holiday), and I get a circular reference.

How are you used to deal with it?

Thanks!

[Greg_Deckler · Accepted solution]

In some cases, you will want to create another duplicate calendar table that you relate to your other date. The other option is to use the USERELATIONSHIP with measures but that may not work in your specific case.

[CoboleiroBr]

Hi @Greg_Deckler !

I'm already using USERELATIONSHIP in measures, but I didn't find a solution in this case besides creating other Calendar Table...

Thanks!

[Greg_Deckler]

Once I toyed around with creating a third calendar table related to my two calendar tables and using that as my central calendar table but I am pretty sure that ran into issues. I'd have t revisit.