Forum Discussion
sacheu
Microsoft Employee
Microsoft EmployeeHow to have 2 active relationships between 2 tables
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 w...
sacheuMicrosoft Employee
Microsoft EmployeeThanks for your solution. Having 1 index column let me to get to this state:
1. click visual for Column A of Table1, visual for Table 2 will be filted to show its Column A of what is selected
2 click visual for Column B of Table1, visual for Table 2 will be filted to show its Column B of what is selected
But how can I filter Table 2 of what is selected of Column A *AND* Column B of Table 1?
AlexisOlson
Super User
Super UserSince the index I suggested is for unique combinations of both A and B, it will cross filter both.