Relationship between 2 tables

Question

Customers column in table _01_customers has active relation with&nbsp;Quarters column in 06. NPS Bucketing - 2020unable to create relationship with customers with Loyalty level.&nbsp;

fowmy · Answer

Anonymous&nbsp;&nbsp;What is the error?Make sure you follow the guidelines when creating relationships. One table should have unique values.Refer this article:&nbsp;https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-manage-relationships________________________Did I answer your question? Mark this post as a solution, this will help others!.I accept KUDOS 🙂YouTube, LinkedIn

anonymous · Answer

customer table has all customer names and loyalty table has Detractor, Passive, Promoter , these 3 values only.

There is 1 other active relationship between these 2 tables is Customer and Quarters .

fowmy · Answer

Anonymous&nbsp;You cannot have more than one active relationship. You create inactive relationships and create your DAX formula using USERELATIONSHIP.https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in-power-bi________________________Did I answer your question? Mark this post as a solution, this will help others!.I accept KUDOS 🙂YouTube, LinkedIn

anonymous · Answer

I created another table with the required fields and created a relationship, it worked.

fowmy · Answer

Anonymous&nbsp;Great !That was the 2nd option I mentioned and it recommended.Accept the solution if it works for you________________________Did I answer your question? Mark this post as a solution, this will help others!.I accept KUDOS 🙂YouTube, LinkedIn&nbsp;

Forum Discussion

Relationship between 2 tables

5 Replies

Related content

Relationship with Fact tables

Relationship

Relationship Issue

Relationships

Creating relationships