Forum Discussion
Relationships between multiple tables
I have 7 tables in the report.
The main table has customer name, date/quarter,Leader,Location, NPS score etc.
The other 6 tables has customer name, date/quarter,Leader,Location along with their TAT as one of the field.
I have created relationship for customer name from main table to all other tables and when creating relationship between date/quarter,Leader,Location from main table to other tables, it is throwing out error "You cant create direct active relationship....."
Solutions please
Anonymous
Your model is full of bi-directional relationships.
Create a single customer table with unique customers if you don't have one then, create relationships One-To-Many as cardinality with other tables.
Refer link: https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-manage-relationships
https://www.youtube.com/watch?v=-4ybWQSRcOY________________________
Did I answer your question? Mark this post as a solution, this will help others!.
I accept KUDOS 🙂
4 Replies
Anonymous
Can you show a picture of your model to see the relationships?
Check this article at the same time, if you use BI-Directional:
https://community.powerbi.com/t5/Desktop/Bi-directional-cross-filtering-ambiguity/td-p/119890________________________
Did I answer your question? Mark this post as a solution, this will help others!.
I accept KUDOS 🙂
Anonymous
Your model is full of bi-directional relationships.
Create a single customer table with unique customers if you don't have one then, create relationships One-To-Many as cardinality with other tables.
Refer link: https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-manage-relationships
https://www.youtube.com/watch?v=-4ybWQSRcOY________________________
Did I answer your question? Mark this post as a solution, this will help others!.
I accept KUDOS 🙂