Create table based on conditions in the current table

[bloffet]

Hi all,

I've an "Employee" table which contains all the employees from a company. In this table, in addition to the name, function, etc. there is one column with the employeeID, and another one with the ManagerID (each manager is also a row in the Employee table, and thus has an employeeID too).

I'd like to create a separate table to store only Managers.

Could help me on the filter to use to build this ?

Manager = CALCULATETABLE('Employees; 'Employees'[MANAGERID] in (...))

I know how I would do it in SQL, but not really in Power BI with DAX formulaes.

Thanks for your help

Benoît

[Mahesh0016]

@bloffet 
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.