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.

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
Resident Rockstar
6 years ago

Anonymous,

 

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