Forum Discussion

Kelderic's avatar
Kelderic
Helper I
1 year ago
Solved

Two Relationships Between the Same Two Tables

I have an odd data structure in my ERP. A/R Transactions (invoices, credit memos, etc) is a parent table, and A/R Applications is a child table. However, the applications are linked to TWO records in...
Need Help
  • Deku's avatar
    Deku
    1 year ago

    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

pbiuseruk's avatar
pbiuseruk
Resolver IV
1 year ago

Hello,

 

Deku posted some really useful information - just want to expand on some points as it may be useful.

 

You can only make 1 active relationship between 2 tables but you can actually make more than one (the others would be inactive). In order to use the other relationships, you can use the USERELATIONSHIP function within your dax code.

 

The last thing to mention is that you can also duplicate the table and then make one relationship to each of them (this is bad practice though as you're duplicating the data).