Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
henrydhs
Frequent Visitor

Problem - Manage Relationships

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

1.png2.png3.jpg4.png

 

1 ACCEPTED SOLUTION
v-nuoc-msft
Community Support
Community Support

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.

 

View solution in original post

1 REPLY 1
v-nuoc-msft
Community Support
Community Support

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.

 

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors