Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Manage the ambiguity problem between 2 tables

Hi Everybody, 

 

I'm Melvin, i'm a beginer in Power BI. 🙂

 

I'm trying to connect some tables, but i have a problem with ambiguity in the relationships.

 

I would like to connect one table of data (USER) to a the main table, with two relationships :

- USER to AUDITOR

- USER to PARTICIPANT

 

Both of Auditor and Participant use the same User table. 

I Create an example to illustrate my problem : 

 

I have an "audits" table that uses 2 differents databases to fill 3 data field.
I can connect my "clients" database with the "clients_id" field of the "audits" table but I can't connect user_id with participant and user_id with auditor simultaneously. 

 

How can I connect 2 field of my AUDIT  table to the USER table ? 

 

I watch some tutos about this subject but i don't understand how to manage this problem. 

 

Thanks a lot for yout Help 😉 

 

         

 

 

 

 

 

1 Reply

  • You may need to duplicate the User table, and join either to one field or the other. Power BI is not like MDX cubes where you could have 'role playing dimensions'.