Calculate Pass/Fail rate as a percentage by week

[zwambold]

Hi All, 

Need help with what I believe is a relatively simple formula but I'm a bit green. 

Ultimately, I want to show a week over week pass rate as a percentage. Something like below: 

Count of Pass by SR_ID per week/Count of Overall SR_ID per week

I want to then graph this out in a bar chart showing percentage pass by week. 

[rohit_singh · Accepted solution]

Hi @zwambold ,

Create a measure like below :

Pass % =

var _pass =

CALCULATE(

COUNT(Results[SR_ID]),

FILTER(

ALLEXCEPT(Results, Results[Week]),

Results[Overall] = "Pass"

)

)

var _total =

CALCULATE(

COUNT(Results[SR_ID]),

ALLEXCEPT(Results, Results[Week])

)

var _res = DIVIDE(_pass,_total, 0)

return

if(isblank(_res), 0, _res)

Output :

If you want to sort the week in ascending/descening order, create a year-week index column in power query and sort the week column by that.

Kind regards,

Rohit

Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂