Measure to display name of employee based on selected employee ID

[JS00]

Hello,

I have a table (Sales) with Employee ID and their sales, and another table (Employee) with Employee's names/ID. (Employee). 

Employee table has a one to many relationship with the Sales table (linked through the ID column). 

I want to display the employee's name based on the employee ID selected, if none selected, I don't want to display anything. 

I tried the measure of SELECTEDVALUE('Employee'[Name], ''), but it isn't working.

Thank you in advance.

[AnkitaaMishra · Accepted solution]

Hi @JS00 , 

you can use below DAX to create the measure : 
if you select any customer ID, it will give you the customer name or if nothing is selected then it will be blank.

[qqqqqwwwweeerrr · Accepted solution]

Hi @JS00 

I am not sure wether you want single select or multiple selection i have tried which works for both single or multiple selection. 
Create this measure: 

select name = CALCULATE ( IF ( ISFILTERED ( emp_name[ID] ), 1, 0 ), ALLSELECTED ( emp_name ) ) once you create this apply this to filter and name in table 
check below image:

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Check for more interesting solution here: www.youtube.com/@Howtosolveprobem

Regards

[AnkitaaMishra · Accepted solution]

Hi @JS00 , 

you can use below DAX to create the measure : 
if you select any customer ID, it will give you the customer name or if nothing is selected then it will be blank.