Powerbi table connection

[Greg0ry]

In powebi, in linking tables and model view, I can't link 3 tables. Can you help me? The 3 tables are "sales table", "customers table" and "objectives table". The “sales table” is linked to the “customers table” with the “customer code” key. The "sales table" contains the "date" column. The “customers table” contains the “promoter” column. I want to connect the "objective table" which contains the "date" and "promoter" columns with the "sales table" and "customers table", but it does not work.

[Greg0ry]

Thanks but what is the solution?

[danextian]

Hi @Greg0ry 

What you're attempting to do will create ambiguity. Vente is already linked to Clients, and Clients are connected to Objectifs. If you establish a direct relationship between Vente and Objectifs, it will result in a circular relationship. When using columns from these tables, it becomes unclear which relationship will take precedence: Vente to Clients/Objectifs, Objectifs to Clients/Vente, or Clients to Vente/Objectifs.