Forum Discussion
Solved
Diversity calculation
Hello,
Need help on calculation.
Formula: (count of active female employees in Department / Total employees in department)*100
Data:
| Department | Gender | ID |
| Dept1 | Male | 11 |
| Dept1 | Male | 12 |
| Dept1 | Male | 13 |
| Dept1 | Female | 14 |
| Dept1 | Male | 15 |
| Dept1 | Female | 16 |
| Dept2 | Male | 17 |
| Dept2 | Male | 18 |
| Dept2 | Male | 19 |
| Dept2 | Female | 20 |
| Dept2 | Male | 21 |
| Dept2 | Female | 22 |
| ID | Active |
| 11 | 1 |
| 12 | 1 |
| 13 | 1 |
| 14 | 1 |
| 15 | 1 |
| 16 | 1 |
| 17 | 1 |
| 18 | 1 |
| 19 | 1 |
| 20 | 1 |
| 21 | 0 |
| 22 | 0 |
Result
| Department | % Diversity |
| Dept1 | 33 |
| Dept2 | 25 |
kodnil2020
Try this Measure:Measure = VAR _TotalEmployees = CALCULATE( COUNTROWS(Department),IDs[Active]=1) VAR _Female = CALCULATE( COUNTROWS(Department), IDs[Active]=1, Department[Gender]="Female" ) RETURN DIVIDE( _Female, _TotalEmployees )________________________
Did I answer your question? Mark this post as a solution, this will help others!.
I accept KUDOS 🙂
4 Replies
kodnil2020 , Try a new measure like
divide(calculate(count(Table[ID]), Table[Gender]= "Female"),calculate(count(Table[ID])))
kodnil2020
Try this Measure:Measure = VAR _TotalEmployees = CALCULATE( COUNTROWS(Department),IDs[Active]=1) VAR _Female = CALCULATE( COUNTROWS(Department), IDs[Active]=1, Department[Gender]="Female" ) RETURN DIVIDE( _Female, _TotalEmployees )________________________
Did I answer your question? Mark this post as a solution, this will help others!.
I accept KUDOS 🙂
It is taking Total Active instead of Total Department Active.
One more query: How can i show Avergage at the bottom:
Department % Diversity Dept1 33 Dept2 25 Average 29 Fowmy Its working for me. Please ignore earlier comments
