Forum Discussion
Two Relationships Between the Same Two Tables
You can only setup a single active relationship between two tables. You can concatenate the two fields in each table to make a single field for the join.
Alternatively you can use calculate( something,( treatas( ARTransaction[ARTransNum], ARApplication[ApplyToARTransNum])) to create a virtual relationship for a given measure.
The exact implementation will depend on what you are trying to do
It's a little crazy to me that that limitation exists when something like 4D has been able to do multiple named relationships since 2001. Power BI is supposed to be top of the line, lol. Regardless, thank you for the answer.
True and no worries. As an actual solution for what you're trying to do - I'd probably recommend making 2 actual reports instead. Double the maintenance but it would be the cleanest UX.
