Difficulties with Active and Inactive Relationships

[angelompcunha]

I'm attempting to build a dashboard that will show, among other stuff, the volume of trouble tickets created and closed by the team.

I have 2 tables, one for tickets created ( Raised Table)  and another for tickets closed (Resolved Table).

I also have 2 secondary tables for Date and Time which have an active relationship to both Raised and Resolved table and are related to the Creation Date, Creation Time, Closed Date and Closed Time.

What I wanted to do is to select in the visual for the tickets created and that will show from those tickets that were created, which ones were closed in the visual that shows the volume of tickets closed.

In order to do this and since I already got an active relationship between the Raised Table and Date Table and also the Time Table, I have created another table that would serve as an index using the Ticket ID as key since that is unique.

My problem is that I can have an active relationship between the Raised Table and the index table but I can't have an active relationship between the REsolved table and the index table, I receive the ambiguity error between the Resolved Table and Date Table and honestly, I don't understand why since I don't have duplicate records or something out of the ordinary.

I'd like to avoid using the RELATIONSHIP DAX Formula that's why I tried to set it up like this.

Does anyone have any suggestions for what I may be doing wrong?

(Disregard the Backlog table as that is for testing only at the moment)

[angelompcunha]

That's what I've done. Since I merged those 2 tables now I've run into the problem of relating the Created Date and the Resolved Date but I don't think there is any way around it other than using the USERLATIONSHIP function. I think I must compromise between relating the Incident ID or the date

[lbendlin · Accepted solution]

The first thing I would do is to combine the Raised and Resolved tables into a single ticket lifecycle table. Then you would remove the ambiguity.  Keep the date and time tables linked to the date and timestamp in the lifecycle table.