Data issue between tables

[nicksearle1966]

Hi All

I am so new to power-bi and have been following tutorials to create my first info graphic.  Whilst its raw and needs some work, its showing me pretty much what I am looking for.  However, there is a single issue that I cannot rectify and dont understand. 

If I click on the GP by salesperson it highlights that single salesperson in both the table I slect and also the targets table opposite.  It does this for all 17 sales people but the one annomaliy is that wehn I select Nick Searle, it highlights 3 people in the GP targets table and puts the total of the 3 people in the card table below.  It only happens with this salesperson and I am at a loss to understand why.  Sorry for quality of photo but I hope you can see the issue as Nick Searle is highlighted on right but on left Nick Searle, Dayle Hughes and John Goodall are highlighted.  

Sorry for crude photo

[v-xicai]

Hi @nicksearle1966 ,

For the relationship, recommend you create the star schema instead of circle schema, so you may delete the secondary relationships among these tables to break circle , and change the Cross filter direction of relationships from Single to Both , which will take these tables treated as a single table.

When you make some selections on one field of one table, then the other tables will return the corresponding result. You can learn more about relationship .

Best Regards,

Amy 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

Would need to understand the data better. Probably something related to a relationship. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[nicksearle1966]

@Greg_Deckler Thanks Greg - I am not sure how it can be a relationship as I just created the tables from the data and every other link when clicking on the individuals works perfectly.....Jessica matches with Jessica, Dayle matches with Dayle.  Its only when I click on Nick that for some reason it highlights 3 different people.  I am not sure I am going to be able to solve it as I have limited knowledge at the moment and am going to have to learn alot more before I am able to resolve this kind of issue.

Thanks anyway.

[Greg_Deckler · Accepted solution]

Well, Power BI creates those relationships automagically most of the time. You need to inspect your data model and the data. So, for example of how this could happen. Suppose you have an employee id and that is what Power BI decided to make the relationship on. Except that your data is bad and you have the same employee id for 3 different people in one of the tables. Well, there you go. So, I would start by looking at your data model and seeing what columns the relationship is built on. You just need to double-click the relationship or click on the relationship and see what columns get highlighted.