Multiple attributes Relationship

[Anonymous]

Hi, 

Can you please help me with the below case? 

So lets say I have 3 tables

1. All tickets (Request ID, Techincian, Created Date)
2. Tasks(Task ID, Owner, Created Date)
3. Date Table

I have a slicer that would filter on Month (Date) and Department (Technician grouped) ... However, my visuals from the task table do not work because technican is taken from the All tickets.

Is there a way if I can have a relationship between Techincan and Owner that would allow me to create a slicer that would filter on all visuals? 

Ps. Bare in mind the people in Technicans are the same employees in owners - just named differently in that table on the sql server. I tried also connecting them but it didn't work out. 

[Anonymous · Accepted solution]

Hi @Ashish_Mathur @lbendlin 

Thank you both for the above suggestions. I managed to find a fix.

I made all the relationships btw those tables as inactive and used the userelationship function while kept the relationship between tech and owner as active and it fixed the issue. 

[Ashish_Mathur]

Hi,

Share the 3 datasets, describe the question and show the epxected result.

[lbendlin]

Move the technicians out into their own dimension table.