how do I properly create a relationship between 2 tables

Hi  Anonymous ,

According to the error message: there is no shared dimension between the two tables, and the fields of the join relationship do not have unique values.

Try adding a calculated table and using many-to-one relationship:

Solved: Create join table for many to many relationship DA... - Microsoft Fabric Community

https://radacad.com/creating-a-shared-dimension-in-power-bi-using-power-query-basics-and-foundations-of-modeling

Solved: Re: Unique values from two columns - Microsoft Fabric Community

Best Regards,

Liu Yang

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

You need to create a proper Account dimension table (with unique Account No values) and then comtrol your two tables through it.

Avoid linking fact tables directly.