Forum Discussion

akhreis's avatar
akhreis
New Member
3 years ago
Solved

Filtering Table based on field in another table

I have headcount data which includes the period, employee ID, employee name, job title, manager ID, and manager name.   I'm trying to create a visual where if an employee ID is filtered in Table 1,...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi akhreis 

    You can create a same table, but it does not have relationship with the original table.

    then use the new table as table 1, the original table as table 2

    then create a measure in original table"

    Measure = IF(ISFILTERED('Table (2)'[Employee ID])=FALSE(),1,IF(MAX('Table'[Manager Name])=MAX('Table (2)'[Name]),1,0))

    put the measure to the visual filter of table2

     

    Output

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi akhreis 

You can create a same table, but it does not have relationship with the original table.

then use the new table as table 1, the original table as table 2

then create a measure in original table"

Measure = IF(ISFILTERED('Table (2)'[Employee ID])=FALSE(),1,IF(MAX('Table'[Manager Name])=MAX('Table (2)'[Name]),1,0))

put the measure to the visual filter of table2

 

Output

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • akhreis's avatar
    akhreis
    New Member
    3 years ago

    Woohoo! Perfect!