Problem - Manage Relationships

[henrydhs]

Hello everyone,
I have a problem. I have a data table with defects, and I intend to link it to several columns in another table. However, it only allows one active table-to-table relationship. How can I interconnect the others?

I created a measure in order to be able to connect. But it doesn't work well

[v-nuoc-msft · Accepted solution]

Hi @henrydhs 

You can try the following actions:

Create a new table that integrates the information needed in both tables. A bridged table can have foreign keys that reference primary keys in the other table so that you can indirectly join multiple columns.

Instead of a metric table, you can create calculated columns in one of the tables to reference the other table. This way, you can pull in relevant data without having an active relationship.

You can create multiple relationships, but only one can be active at a time. You can then use DAX to switch between these relationships as needed.

DAX functions such as RELATED() and RELATEDTABLE() can help you pull in relevant data from another table without the need for an active relationship.

If you're still having problems, provide some dummy data and the desired outcome. It is best presented in the form of a table.

Regards,

Nono Chen

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