Need advice on relationship multiple table

[Anonymous]

Hello Everyone.

I got a table who contains several ID adress, like, one id for shipping / sales / paiement. And i got just on table adress.

But i can join several times two tables exact ? 

Please need help 😞

[Anonymous · Accepted solution]

Hi @Anonymous ,

There is only one active relationship between two tables. If you want an additional relationship when a relationship has been built, the new relationship will be inactive and the relationship line is dotted line. As the official document said:

Once you've connected two tables together with a relationship, you can work with the data in both tables as if they were a single table, freeing you from having to worry about relationship details, or flattening those tables into a single table before importing them.

For how to build relationships,please refer to:

Create and manage relationships in Power BI Desktop - Power BI | Microsoft Docs

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

[Anonymous]

Thanks for your answer ! I try the second way, but i got 8 table in this way, i think it's way to much, and i have to wait maybe 1 minute when i want rename a field.

@Greg_Deckler In the first way, how can i use this ? Because i need to display the four adress in the same table.

[Greg_Deckler]

@Anonymous Two ways to go about this. One, you can create two relationships. One will be inactive and you can use USERELATIONSHIP in a measure to force which one you want to use. Second way, duplicate your address table creating two "scenario" dimensions such as a Shipping dimension and Accounting dimension.