Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Filter a visual table using selected row in another visual table

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...
General Comment
Need Help
Tips and Tricks
  • PattemManohar's avatar
    PattemManohar
    7 years ago

    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's avatar
Anonymous
Not applicable
7 years ago

Thanks PattemManohar 

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

thanks all for the support.