Extract specific rows from table

[pgoum]

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

[jdbuchanan71 · Accepted solution]

Hello @pgoum 

Give this a try.  

Managers = 
VAR ManagerList = DISTINCT( Employees[manager] )
RETURN 
CALCULATETABLE(
    SUMMARIZE(
        Employees,
        Employees[EmpID],
        Employees[EmpName]),
    Employees[EmpID] IN ManagerList
)

[pgoum]

Thanks a lot you're awesome @Zubair_Muhammad  @jdbuchanan71 

[Zubair_Muhammad · Accepted solution]

@pgoum 

Just an alternative

Calc Table =
CALCULATETABLE (
    Employees,
    TREATAS ( VALUES ( Employees[manager] ), Employees[empID] )
)

[jdbuchanan71 · Accepted solution]

Hello @pgoum 

Give this a try.  

Managers = 
VAR ManagerList = DISTINCT( Employees[manager] )
RETURN 
CALCULATETABLE(
    SUMMARIZE(
        Employees,
        Employees[EmpID],
        Employees[EmpName]),
    Employees[EmpID] IN ManagerList
)