Forum Discussion

pgoum's avatar
pgoum
Frequent Visitor
6 years ago
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 enou...
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    6 years ago

    Hello pgoum 

    Give this a try.  

    Managers = 
VAR ManagerList = DISTINCT( Employees[manager] )
RETURN 
CALCULATETABLE(
    SUMMARIZE(
        Employees,
        Employees[EmpID],
        Employees[EmpName]),
    Employees[EmpID] IN ManagerList
)
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    6 years ago

    pgoum 

     

    Just an alternative

     

    Calc Table =
CALCULATETABLE (
    Employees,
    TREATAS ( VALUES ( Employees[manager] ), Employees[empID] )
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
6 years ago

pgoum 

 

Just an alternative

 

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