topic Calculate Pass/Fail rate as a percentage by week in DAX Commands and Tips

Calculate Pass/Fail rate as a percentage by week

zwambold — Thu, 16 Jun 2022 15:30:56 GMT

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.

Re: Calculate Pass/Fail rate as a percentage by week

rohit_singh — Thu, 16 Jun 2022 16:39:25 GMT

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! 🙂

Re: Calculate Pass/Fail rate as a percentage by week

IvoA93 — Tue, 13 Jan 2026 15:32:35 GMT

This calculation works for a very similar set of data i have. however i have an extra colum called Site as we have two Sites. When i filter one or the other on a slicer it doesnt react. how would i enable this code to work but also filter by site so that i can choose one site or the other or both together?

Re: Calculate Pass/Fail rate as a percentage by week

rohit_singh — Tue, 13 Jan 2026 15:38:20 GMT

IvoA93 You can try modifying the context by adding site, something like
ALLEXCEPT(Results, Results[Week], Results[Site])
Maybe that would give yiou what you need