Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
@bloffet
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
28 | |
12 | |
10 | |
10 | |
6 |