How to have 2 active relationships between 2 tables

Question

I have 2 tables, each of them has its visual in PowerBI.
And there is currently 1 active relationship between them.

My question is how can I add a 2nd active relationship between them?
so that when I click on 1 item in 1 visual, the other table will get updated and Vice versa.

Table 1:

Column A

Column 1

Column 2

Column 3

Column B

Table 2:

Column A

Column 5

Column 6

Column 7

Column B

I want Column A and Column B to be active relationships.

Thank you.

Sam

sacheu · Answer

So 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.

parry2k · Answer

sacheu you cannot have&nbsp;more than one active relationship, you have to use userelationship function to use inactive relationship.

alexisolson · Answer

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 · Answer

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.&nbsp;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.&nbsp;&nbsp;&nbsp;

alexisolson · Answer

OK, then a creating a common key/index/ID for each unique A,B pair in the query editor is a decent solution.&nbsp;Here's an example of how this works:http://radacad.com/relationship-in-power-bi-with-multiple-columns

Forum Discussion

How to have 2 active relationships between 2 tables

9 Replies

Related content

Relationship

relationship active & inactive

Ignoring an active relationship

Relationships

Relationship Issue