topic Re: Measure to display name of employee based on selected employee ID in DAX Commands and Tips

Measure to display name of employee based on selected employee ID

JS00 — Tue, 25 Jun 2024 12:06:04 GMT

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.

Re: Measure to display name of employee based on selected employee ID

AnkitaaMishra — Tue, 25 Jun 2024 13:53:04 GMT

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.

Re: Measure to display name of employee based on selected employee ID

qqqqqwwwweeerrr — Tue, 25 Jun 2024 14:17:54 GMT

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