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