MEASURES
- Total Emp = COUNTROWS('HR Analytics Data')
- Male = Calculate([Total Emp],'HR Analytics Data'[Gender]="male")
- Female = Calculate([Total Emp],'HR Analytics Data'[Gender]="female")
- % male = DIVIDE([Male], [Total Emp], 0)
- % female = DIVIDE([Female], [Total Emp], 0)
- Due for promotion = CALCULATE([Total Emp], 'HR Analytics Data'[Promotion Status]="Due Promotion")
- Not Due = CALCULATE([Total Emp], 'HR Analytics Data'[Promotion Status]="Not Due")
- % Due for promotion = DIVIDE([Due for promotion], [Total Emp],0)
- % Not Due = DIVIDE([Not Due], [Total Emp],0)
- On Service = IF(ISBLANK(CALCULATE([Total Emp], 'HR Analytics Data'[Retreanchment Status]="On Services")),0,CALCULATE([Total Emp], 'HR Analytics Data'[Retreanchment Status]="On Services"))
- % On Service = DIVIDE([On Service], [Total Emp], 0)
- Will be Retreanched = IF(ISBLANK(CALCULATE([Total Emp], 'HR Analytics Data'[Retreanchment Status]="Will be Retreanched")),0,CALCULATE([Total Emp], 'HR Analytics Data'[Retreanchment Status]="Will be Retreanched"))
- % retreanched = DIVIDE([Will be Retreanched], [Total Emp], 0)