Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello Everyone,
I need to find the no of employees under a manager?
Table: "emp_tbl"
Do I need a self join or group by in DAX?
Solved! Go to Solution.
Hi @Anonymous ,
According to my understanding, you want to count the number of Emp under each manager when their type is “New Joiners”, right?
You could use the following formula:
No of Emps =
COUNTROWS (
FILTER (
ALL ( emp_tbl ),
emp_tbl[Manager] = MAX ( emp_tbl[Manager] )
&& emp_tbl[Emp type] = "New Joiners"
)
)
My visualization looks like this:
Is the result what you want? If not, please upload some data samples and expected output.
Please do mask sensitive data before uploading.
Best Regards,
Eyelyn Qin
HI @Anonymous ,
Did I answer your question ? Please mark my reply as solution. Thank you very much~
If not, please upload some insensitive data samples and expected output.
Best Regards,
Eyelyn Qin
Hi @Anonymous ,
According to my understanding, you want to count the number of Emp under each manager when their type is “New Joiners”, right?
You could use the following formula:
No of Emps =
COUNTROWS (
FILTER (
ALL ( emp_tbl ),
emp_tbl[Manager] = MAX ( emp_tbl[Manager] )
&& emp_tbl[Emp type] = "New Joiners"
)
)
My visualization looks like this:
Is the result what you want? If not, please upload some data samples and expected output.
Please do mask sensitive data before uploading.
Best Regards,
Eyelyn Qin
@Anonymous - What is your expected output from your sample data? This may be a transitive closure situation, I remember doing something similar to this in the past and I believe it was a spin on transitive closure. The specific problem was related to calculating commissions for a sales person hierarchy.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Transitive-Closure/m-p/783828#M388
Basically you have to walk the hierarchy unless you are just going for direct reports. The PATH functions may be of use.
https://docs.microsoft.com/en-us/dax/path-function-dax
@Anonymous , you need to create an employee table and join it both with Emp and manager. Keep emp join active and manager join inactive and when to want to know employee under manager the activate the join using userelation
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
105 | |
78 | |
68 | |
63 |
User | Count |
---|---|
148 | |
107 | |
106 | |
84 | |
70 |