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.

v-juanli-msft's avatar
v-juanli-msft
Community Support
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

    Thank you! I will try this one later and will let you know if it works.

     

    Appreciate your help! 🙂 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi v-juanli-msft,

     

    Thank you. I think this is the right route but I have one more problem this:

    'Table'[Unit Pass?]

     is actually nonexistent to my table, I also need a formula that does this.