Forum Discussion
Need advice on relationship multiple table
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 😞
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.
3 Replies
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.
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.
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.
