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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.