Relationships between multiple tables

[Anonymous]

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

[Fowmy]

@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 🙂

YouTube, LinkedIn

[Anonymous]

[Fowmy · Accepted solution]

@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 🙂

YouTube, LinkedIn

[Anonymous]

created single customer tables Thanks