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
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.
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.
Helpful resources
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
