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