How to form a DAX between a table and the selected value in the slicer

[Anonymous]

Hi, 

I'm new to Power BI, and I'm stuck with the below issue

I have a table, say A. and I have a slicer , which dropdowns all the employee nums in the table A. Now I need to create a measure where, the table with all records are displayed and based the employee number selected in the slicer, for that particular row in table that row needs to be highlighted. 

The employee number in the slicer changes everytime when the table is refreshed. Please help

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

To create a calculated table based on the employee column in the fact table.

Slicer = VALUES(Table1[employee])

Create a measure as below and make the visual formatted by it as the picture.

Measure = 
VAR _list =
    VALUES ( 'Slicer'[employee] )
RETURN
    SWITCH ( TRUE (), MAX ( Table1[employee] ) IN _list, "#34da22" )

Pbix as attached.

Regards,

Frank

[v-frfei-msft]

Hi @Anonymous ,

Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.

Regards,
Frank