Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Create a relationship between 2 tables using other table.

Hi.

I want to know whether we can create a relationship between 2 tables with the help of other table.

I want to create a relationship between LU_Employee and TRX_LoanApplication, but a similar column is not present in both the tables in order to create a relationship.

So I used FACT_BrokerTarget table to create a relationship between those 2 tables.

 

 

Help will be appreciated.

 

Regards,

Sanket Bhagwat

Need Help

3 Replies

  • Fowmy's avatar
    Fowmy
    Icon for Super User rankSuper User
    5 years ago

    Anonymous 

    Not sure about the cardinality of each IDs in those tables, can you share some data as example for the three tables. You may have to create combined keys. You have applied Many to Many relationships which not preferable.


    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi Fowmy .

       

      Cardinality for both the relationships is 'many to many' as other cardinalities were not working.

      For ever other relationship, I got an error as 'The cardinality you selected isn't valid for this relationship.

       

      Here is a sample data of all the 3 tables.

       

      Regards,

      Sanket Bhagwat

       

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous ,

     

    This can be a real hair-puller, especially when the relationship really is 1:1. Ensure you have done the following to the matching keys:
    * Convert the keys to UPPER or lower. Power BI doesn’t consider the same string in upper and lower case to be the same.
    * Remove blanks/nulls
    * Remove duplicates (of course)
    * Remove errors

     

    Please kindly refer to Many-to-One or Many-to-Many? The Cardinality of Power BI Relationship Demystified.

     

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.