Count Values leveraging a unary relationship

[savage63073]

Hi,

I am learning Power BI - hope this question is not too obvious.

I am trying to create a measure which counts values in a data set through a unary relationship.  It's an employee table which includes the employee's manager ID.  I want the measure to tell me, for each employee, how many other employees they manage.  The image included articulates it pretty well - trying to create the "Number Direct Reports" column.  Appreciate any ideas, thanks!

[Jihwan_Kim · Accepted solution]

Hi, @savage63073 

Please check the below picture and the measure.

 Number of Direct Reports From =
VAR currentid =
MAX ( Data[EmpID] )
RETURN
CALCULATE (
COUNTROWS ( Data ),
FILTER ( ALL ( Data ), Data[ManagerID] = currentid )
) + 0

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

[savage63073]

awesome, thank you!