Forum Discussion

kodnil2020's avatar
kodnil2020
Helper I
6 years ago
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 ...
Need Help
  • Fowmy's avatar
    Fowmy
    6 years ago

    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 🙂

    YouTube, LinkedIn

amitchandak's avatar
amitchandak
Super User
6 years ago

kodnil2020 , Try a new measure like

divide(calculate(count(Table[ID]), Table[Gender]= "Female"),calculate(count(Table[ID])))