Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Create table based on conditions in the current table

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



Helpful resources

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!