Forum Discussion
Creating relationships between tables that contain duplicate values
Hi FMPE ,
According to your description, it seems that you got some problem when created the relationships between tables. What's your final expected result? It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
In addition, you can refer the following links to create relationship:
Model relationships in Power BI Desktop - Power BI | Microsoft Learn
Create and manage relationships in Power BI Desktop - Power BI | Microsoft Learn
Creating Relationship Based on Multiple Fields in Power BI Using TREATAS DAX Function - RADACAD
Solved: Relationships between tables when both have duplic... - Microsoft Fabric Community
Best Regards
Hi FMPE ,
According to your description, it seems that you got some problem when created the relationships between tables. What's your final expected result? It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
In addition, you can refer the following links to create relationship:
Model relationships in Power BI Desktop - Power BI | Microsoft Learn
Create and manage relationships in Power BI Desktop - Power BI | Microsoft Learn
Creating Relationship Based on Multiple Fields in Power BI Using TREATAS DAX Function - RADACAD
Solved: Relationships between tables when both have duplic... - Microsoft Fabric Community
Best Regards
Apologies for the late reply, I have been figuring things out and learning a lot since I made the post, and I somehow overlooked that there had been a reply here. Unfortunately, I am not able to share the .pbix, as the data isn't confidential.
I am going to mark your response as an answer, as my problem has developed into something else entirely, and I'll make a new post for adressing that, instead of editing this one.
Thanks!