Filter a visual table using selected row in another visual table

[Anonymous]

Hi All,
Need a help on achieving the following scenario. I need this to find sutable replacement for the employee who has applied leaves. I want to show two tables in power bi and want to filter the table 2 using table 1. both table are visual tables. 

if i click row of Jack in the table 1, table 2 should be omit the record of Jack as he cannot replace himself and it should show only Managers based on Jack's Job (to find similar available job role). both tables are join using emp id.

table 1 - leave table

table 2 - employee table

[v-chuncz-msft]

@Anonymous ,

You may refer to the post below.

https://community.powerbi.com/t5/Desktop/Tricky-Slicer-Options/m-p/573381#M270846

[Anonymous]

Thanks for the reply @v-chuncz-msft ,

in my case what i am expecting is, when select a row in table 1, the table 2 should filter based on the values in selected row.

 for example i am looking for something like below.

Table = SUMMARIZE('Table2,FILTER('Table2','Table2'[Emp Name]=X))
i need to pass the selected row's Emp Name value to X, so that based on my selection the new table should be change.

[Anonymous]

Any other have face similar issue or scenario ?

[PattemManohar · Accepted solution]

@Anonymous Please try the below steps, might be helpful.

Create a new calculated column in Emp Table as below

LeaveFlag = IF(ISBLANK(LOOKUPVALUE(Test302EmpLeave[EmpID],Test302EmpLeave[EmpID],Test302Emp[EmpID])),"N","Y")

Emp Table     EmpLeave TableRelationship

Emp Table visual

I've tested by adding another clerk in the emp table

[Anonymous]

Hi @PattemManohar 

thanks for the support. Appriciate if you can shrare the pbix file.

[PattemManohar]

@Anonymous Attached !!

[Anonymous]

Thanks @PattemManohar 

your solution is working and found another solution using search and selectedvalue function in a meassure. 

thanks all for the support.