Notifications
Clear all
Power Pivot
2
Posts
2
Users
0
Reactions
82
Views
Topic starter
Hello everyone,
I am working on recruitment dashboard , In the attached file , on one sheet there is list of department wise opening and the second sheet there is list of candidates with remarks whether they are selected or not. By using DAX I want to calculate department wise hired employees. Some how I am not able to calculate it department wise it shows the grand total of hired in the last row.
Kindly help me in calculating hired employees department wise.
Thanks in advance,
Regards,
Tarun Dhiman
Posted : 17/10/2020 12:29 pm
Hi Tarun,
Welcome to our forum.
You don't need a measure for this. Build your PivotTable with the following fields:
Filters: Application Status - select 'Hired'
Rows: Department & Designation from Applications table
Values: Count of Job ID
Mynda
Posted : 17/10/2020 8:02 pm