Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
selected_
Helper IV
Helper IV

I wanna see amount employee per manger

I'm struggling with writing my DAX formula to calcualte Amount Employees per manager

 

so heres how the table looks like

 

employeeIDPositionMangerID
100102Employee111008
100103Employee111008
100100Employee111008
111008
Manager1121101
121101Manager2130241

 

As you can see the ManagerID are the refrence of the respective manager EmployeeID, so even the Manager1 and Manager2 could have another higher Manger of the top. But for now I just wanna see the amount of employees that a certain manager have.

 

Anyone who can help`?

 

1 REPLY 1
cosm
Resolver II
Resolver II

Hi 🙂

For me this seems like you can simply use a distinct count.

For example:
0) Load the data you provided, call the table "Relations" or anything else. 

cosm_1-1687802179891.png

 


1) Create this measure:

unique employees = 
 DISTINCTCOUNT(Relations[employeeID])

2) Add the column "Manager" and the above created measure to a table visual or similar

Result:

cosm_0-1687802130747.png

This should give you the distinct count of employees directly connected to each manager.

 

@selected_ - hope this solves your problem. If so, consider accepting the answer as solution so it will be easier for others to find.


Additional note: It seems that your data may have parent-child hierarchy. E.g.
130241 Manages 121101,
121101 Manages 111008
, so 1303241 mangages 121101 "directly" and 11008 "indirectly" through child 121101.
If you want to account for the child-parent relations, you may want to read documenation of parten-child-functions:
https://learn.microsoft.com/en-us/dax/parent-and-child-functions-dax
https://radacad.com/parsing-organizational-hierarchy-or-chart-of-accounts-in-power-bi-with-parent-ch...

Kind regards!

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.