Forum Discussion
Relationship
Hi,
we have three tables Customer, Customer territory link, Territory.
and the relationship exists as below..
Customer-one to many-Customer territory link
Territory-one to many-Customer territory link
the problem is..
in power bi when i select a customer and territory name i.e. one customer is appearing with all the territories.
Actual data
Power bi Report data
Thanks
Hi Anonymous
I make a test as below,
sample tables
Relationships
visuals
It works well on my side.
Could you provide some examples for me to reproduce your problem?
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
7 Replies
Anonymous can you provide a screenshot of the relationship diagram? Also, a screenshot of the tables data would be helpful.
Anonymous I understand but seeing the diagram and seeing some of the data from the individual tables helps for troubleshooting. A 2nd set of eyes can go a long way. Not to mention a screenshot is relitivley easy to provide and a picture is worth a 1,000 words.
Hi Anonymous
I make a test as below,
sample tables
Relationships
visuals
It works well on my side.
Could you provide some examples for me to reproduce your problem?
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.what if some ohter relationship between Customer and Territory through other tables.
For Example:
Terriotry->Route
Route->Customer-Route
Customer-Route->Customer
Thanks
Hi Anonymous
It is also possible.
If you have any problem implementing this, please share some example for me to make a test.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
