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

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 Member
Member

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

I already have it in both directions 😞  @MattAllington 

jcastr02 Member
Member

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 Member
Member

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

Highlighted

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 Member
Member

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

How can I attach a pbix file on here?

jcastr02 Member
Member

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
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors