Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Population Pass Rate

Hello Everyone,   Requesting for your help in creating a Population Pass Rate computation wherein the target is dynamic. Please see sample data below:   ID Employee Name Supervisor Units T...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    Hi Anonymous 

    Create measures

     

    pass count =
CALCULATE (
    DISTINCTCOUNT ( 'Table'[Employee Name] ),
    FILTER (
        ALLSELECTED ( 'Table' ),
        'Table'[Supervisor]
            = MAX ( 'Table'[Supervisor] )
            && 'Table'[Unit Pass?] = 1
    )
)

total emp =
CALCULATE (
    DISTINCTCOUNT ( 'Table'[Employee Name] ),
    FILTER (
        ALLSELECTED ( 'Table' ),
        'Table'[Supervisor]
            = MAX ( 'Table'[Supervisor] )
    )
)


pass rate = [pass count]/[total emp]

     

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

rajulshah's avatar
rajulshah
Icon for Resident Rockstar rankResident Rockstar
6 years ago

Hello Anonymous,

 

I did not fully understand your issue, but are you facing issue calculating Pass rate?

If yes, please use:

Pass Rate = 
VAR PassCount =  CALCULATE(DISTINCTCOUNT(Table[ID]),Table[Unit Pass?]=1)
VAR TotalEmployees = DISTINCTCOUNT(Table[ID])
RETURN DIVIDE(PassCount,TotalEmployees)

 

If not, please guide ahead. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi,

     

    Thank you for your prompt response and apologies if I wasn't able to explain it better.

     

    What I really need is:

    - A dynamic target that changes based on the selected date coverage. The target is the average of all the data per employee.

    - Pass Count measure if the employee passes (value is 1 or 0), the total should also show how many passed

     

    Lastly, a table that will summarize this by supervisor shown in the table above

    • rajulshah's avatar
      rajulshah
      Icon for Resident Rockstar rankResident Rockstar
      6 years ago

      Anonymous,

       

      I cannot understand. Can you show your current data vs expected data?