Forum

Dax to calculate pa...
 
Notifications
Clear all

Dax to calculate particular data in Power pivot

2 Posts
2 Users
0 Reactions
82 Views
(@kanu)
Posts: 3
Active Member
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
(@mynda)
Posts: 4761
Member Admin
 

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
Share: