Filter for Duplicates in the same table from two different columns and relate to third column

[unknown_anony]

Hello,

I have a table of Employee master with Employee id(Employees and manger IDs) , manager id and emp country . I have to filter out the manger id from the employee id and related country in a calculated column.
below screenshot will explain the situation.

How can we do that?
All suggestions are welcome

Thank you

[unknown_anony]

Worked smoothly thank you so much

[v-tangjie-msft · Accepted solution]

Hi @unknown_anony ,

According to your description, here are my steps you can follow as a solution.

(1) My test data is the same as yours.

(2) We can create a calculated column.

Manager country = CALCULATE(MAX('Table'[Emp country]),FILTER('Table','Table'[Emp id]=EARLIER('Table'[manager id]))) 

(3) Then the result is as follows.

Best Regards,

Neeko Tang

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