Forum Discussion
Microsoft EmployeeHow to have 2 active relationships between 2 tables
Super Usersacheu you cannot have more than one active relationship, you have to use userelationship function to use inactive relationship.
Microsoft EmployeeSo if i have 1 active relationship and 1 inactive relationship. Each relationship maps to a different column of the tables.
How can i make the other visual update when i select 1 visual? I thought i need to have active relationship before i can get clicking 1 visual will update another visual working.
- AlexisOlson
You'll likely need some kind of bridge table or combined index to relate the tables. Can you describe what are in those A and B columns?
- sacheu
Both ColumnA and ColumneB are string. And there can be multipe row with same value in Table1 and Table2.
So Table 1 and Table 2 shoul dhave a Many - To -Many relationships with ColumnA and ColumnB.
Althought there can be multiple row with same values in ColumnA and Column B, But the combination of ColumnA and ColumnB values is unique in Table 1 and Table 2.
- AlexisOlson
OK, then a creating a common key/index/ID for each unique A,B pair in the query editor is a decent solution.
Here's an example of how this works:
http://radacad.com/relationship-in-power-bi-with-multiple-columns
