cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nicksearle1966
Regular Visitor

Data issue between tables

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 photoSorry for crude photo

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


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

4 REPLIES 4
v-xicai
Community Support
Community Support

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
Super User IV
Super User IV

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


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




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

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.


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors