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.
Hi,
We have two table Employee and Supervisor
where emp.emp_id = supervisor.supervisor_id (self join type)
Now we need report in below format
Employee Count Supervisor Count
0-5 10
6-15 20
16-20 30
Basicaally it will show 10 Supervisors handle a count of 0-5 Employees
Any help on how this report can be created .
Tried few measures creation but not able to achieve like above
Any suggestios pls
Solved! Go to Solution.
Hi @GuestUser
Emp I'd. Supervisor id
1. 11
2. 11
3. 222
4. 222
5. 222
11. 333
Need to cretae a reprot like below
Emp count. Supervisor count
0-2. 3 I assume it should be 2 not 3, right?
3-5. 1
Please check whether you'd like to get below results:
Pbix attached for your reference.
Hi @GuestUser
Sorry not quite understand your requirement, you might consider creating pbix file that will contain some sample data (remove the confidential info), upload the pbix to onedrive or dropbox and share the link to the file. Please do not forget to describe the expected results based on this sample data.
Hi @GuestUser
Emp I'd. Supervisor id
1. 11
2. 11
3. 222
4. 222
5. 222
11. 333
Need to cretae a reprot like below
Emp count. Supervisor count
0-2. 3 I assume it should be 2 not 3, right?
3-5. 1
Please check whether you'd like to get below results:
Pbix attached for your reference.
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.