Problem - Manage Relationships

henrydhs — Thu, 11 Apr 2024 08:47:28 GMT

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

Re: Problem - Manage Relationships

Anonymous — Fri, 12 Apr 2024 03:23:31 GMT

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.

topic Problem - Manage Relationships in DAX Commands and Tips

Problem - Manage Relationships

Re: Problem - Manage Relationships