cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jcastr02 Post Partisan
Post Partisan

Employee ID relationship within 2 tables and Employee Name to display on visual

 

 

I Have two tables

1.  Employee Matrix - hold EVERYONES name and Employee ID

2. Project Table - holds projects with the employee ID only

 

I've created the relationship between the Employee ID already.  When I go to create a visual, I drag the employe name from the matrix and pull data from the project table, it displays ALL employees and not only team members that completed projects.

 

If I select employee ID, the ID will only display and I'm trying to have the Name dispaly on the visual.  How can I get this on visual?

10 REPLIES 10
Super User IV
Super User IV

Re: Employee ID relationship within 2 tables and Employee Name to display on visual

Hi,

Write a measure such as =COUNTROWS(Project) and drag it to your visual.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Re: Employee ID relationship within 2 tables and Employee Name to display on visual

If your tables are small, say less than 1m rows, just turn on cross filtering to both directions. Do this in the relationship view, double click on the relationship and change it there 

 



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
jcastr02 Post Partisan
Post Partisan

Re: Employee ID relationship within 2 tables and Employee Name to display on visual

I already have it in both directions 😞  @MattAllington 

jcastr02 Post Partisan
Post Partisan

Re: Employee ID relationship within 2 tables and Employee Name to display on visual

I have a measure, dragged into visual which is turn around time, but dragging to the axis either the employee ID or the employee name from both tables are not display  Only peole that are in the project.  @Ashish_Mathur

Super User IV
Super User IV

Re: Employee ID relationship within 2 tables and Employee Name to display on visual

Hi,

There is some problem with the relationship.  Share the link from where i can download the PBI file.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
jcastr02 Post Partisan
Post Partisan

Re: Employee ID relationship within 2 tables and Employee Name to display on visual

Re: Employee ID relationship within 2 tables and Employee Name to display on visual

This link doesn't help.  You are having a data modelling issue.  To help you with the issue you need to share the datamodel, and this is only visible in the PBIX file.



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
jcastr02 Post Partisan
Post Partisan

Re: Employee ID relationship within 2 tables and Employee Name to display on visual

How can I attach a pbix file on here?

jcastr02 Post Partisan
Post Partisan

Re: Employee ID relationship within 2 tables and Employee Name to display on visual

Disregard, I found a work around.  Thank you for your help.  

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors