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.