Relationship

[Anonymous]

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

[v-juanli-msft · Accepted solution]

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.

[Anonymous]

Hi @v-juanli-msft 

what if some ohter relationship between Customer and Territory through other tables.

For Example:

Terriotry->Route

Route->Customer-Route

Customer-Route->Customer

Thanks

[v-juanli-msft]

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.

[Anonymous]

Yes. it is working now. the problem was with biderctional functionality.

Thanks

[Justair07]

@Anonymous can you provide a screenshot of the relationship diagram? Also, a screenshot of the tables data would be helpful.

[Anonymous]

hi @Justair07 

i have already mentioned the relationship between three tables in the post.

Thanks

[Justair07]

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