Create a relationship between 2 tables using other table.

[SanketBhagwat]

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

[Anonymous]

Hi @SanketBhagwat ,

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.

[Fowmy]

@SanketBhagwat 

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.

[SanketBhagwat]

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