I have multiple tables but I will only talk about 4 tables first.
I have table “Date”, table “Brand”, table “E” and table “TOP”.
Table E and table TOP are linked to table Date via the column Date (both are in a m:n relationship).
Table E is connected to table Brand via column EAN. Table TOP should also be linked to table Brand via the Brand ID column. But I can’t put table TOP in a relation with table BRAND because it would cause ambiguity error between tables TOP and DATE.
How can I put table TOP in a relation with table Brand?
Is it even possible?
I followed many steps from chatgpd but I couldn’t find a soloution and now it feels like I’m going around a cricle.
Chatgpd suggest me that I put table Date in a relationship with table Brand but that is not possible since they just can’t have a similarity.
If it helps I created a Brand ID column for table E. But then again I can’t put table E in an active relationship with table TOP.
I appreciate every help and idea and it’s great that there is a community for Power BI
Hello @anon, to help the forum members further analyze your current state and visualize your issue, could you please provide as many as you can of:
• Your work-in-progress PBIX file, using sanitized data if necessary
here’s [/u/brianj]@BrianJ’s YouTube video on how to anonymize data in a Power BI file: https://www.youtube.com/watch?v=VmWD7Ayw_NI
• Your dataset as an Excel file (again, sanitized if necessary)
• A detailed mock-up (marked-up screenshot of the visual in question or Excel file) showing your desired outcome.
Also, if you provide DAX or Power Query code in your post, please format it using the built-in formatted.
I could solve my problem.
I searched for similar topics in this forum and noticed that you hardly use m:n relation but 1:n instead. And that there was the case with duplicates.
I still don’t know why but table date was somehow wrong and it had duplicates.
So i deleted table date and added a new table date.
Then I could put table E and TOP in a n:1 relationship to table date.
Later on I created a new table brand with unique data and I put it in a relation to table TOP.
Finally I connected the unique brand table with the table brand.
And now I can visualize table TOP and table E with the unique brand table.
