cancel
Showing results for
Search instead for
Did you mean:
Frequent Visitor

## Calculate number of direct reports as calculated column

Hi

I am trying to calculate number of direct reports in a table and add  as a calculated column as seen below in the last column.

I have monthly data appended to the table every month and the calculation needs to calculate number of direct reports for every month seperately .

Many thanks in advance for any solutions

1 ACCEPTED SOLUTION
Super User IV

This expression should work for your calculated column

``````Direct Reports This Month =
VAR __thisemployee = Employees[EmployeeID]
RETURN
CALCULATE (
COUNTROWS ( Employees ),
ALLEXCEPT ( Employees, Employees[Period] ),
Employees[ManagerID] = __thisemployee
)``````

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.

@mahoneypa HoosierBI on YouTube

2 REPLIES 2
Super User IV
Super User IV

This expression should work for your calculated column

``````Direct Reports This Month =
VAR __thisemployee = Employees[EmployeeID]
RETURN
CALCULATE (
COUNTROWS ( Employees ),
ALLEXCEPT ( Employees, Employees[Period] ),
Employees[ManagerID] = __thisemployee
)``````

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.

@mahoneypa HoosierBI on YouTube

## Helpful resources

Announcements

#### Happy New Year from Power BI

This is a must watch for a message from Power BI!

#### Check it Out!

Click here to read more about the December 2020 Updates!

#### Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

#### Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors