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 ...
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