Forum Discussion
Solved
Extract specific rows from table
Hello guys!
I have a table with employees as shown below. I want to generate a new table containg the names of all those employees who are also managers. I think the two tables make it clear enough.
Employees table (given)
Managers table
So far I have produced the new table containg only the employee IDs that are managers but not sure if that's the right way to proceed.
Managers = FILTER (
DISTINCT (
SELECTCOLUMNS ( Employees, "managerID", Employees[manager] )
),
NOT ( ISBLANK ( [managerID] ) )
)
Thanks in advance,
Panos
Hello pgoum
Give this a try.
Managers = VAR ManagerList = DISTINCT( Employees[manager] ) RETURN CALCULATETABLE( SUMMARIZE( Employees, Employees[EmpID], Employees[EmpName]), Employees[EmpID] IN ManagerList )Just an alternative
Calc Table = CALCULATETABLE ( Employees, TREATAS ( VALUES ( Employees[manager] ), Employees[empID] ) )
3 Replies
Hello pgoum
Give this a try.
Managers = VAR ManagerList = DISTINCT( Employees[manager] ) RETURN CALCULATETABLE( SUMMARIZE( Employees, Employees[EmpID], Employees[EmpName]), Employees[EmpID] IN ManagerList )Just an alternative
Calc Table = CALCULATETABLE ( Employees, TREATAS ( VALUES ( Employees[manager] ), Employees[empID] ) )Thanks a lot you're awesome Zubair_Muhammad jdbuchanan71
:smileylol:
