Hi all,
I have a table titled “Marketing Assets” with many values for the column “Marketing Assets”. I have another table titled “Marketing Assets TopN” with only unique values for Marketing Assets.
I am wondering and need help to know why Power BI is not allowing me to make this a many to one relationship? It is forcing a Many to Many and I can’t do formulas accurately.
Can anyone help.
WIP File.pbix (13.0 MB)
Hello @ysherriff,
Thank You for posting your query onto the Forum.
The reason why it’s forcing to create a “Many-to-Many Relationship” is because you’ve “NULL” values in both the sides of the table. Power BI is not able to distinguish the null value as a each unique value and therefore, it establishes or creates a “Many-to-Many Relationship” in this case.
The fields which are used for creating the relationships should not contain either “BLANK” or “NULL” as a value, atleast not permissble to have it in a Dimension table. It’s not as per the best data modelling practices.
Once you remove the blanks from both of your tables or atleast from the Dimension table then you’ll be able to create the “One-To-Many Relationship” between these tables. Below are some of the links provided pertaining to the best pratices for the reference purposes.
Hoping you find this helpful and solves your issue.
Thanks and Warm Regards,
Harsh
Perfect and excellent!!
Thank you very much.
