Control chart for binary (yes/no) variable

This should not be that hard 🙂 

You have to have some data first. Let's say this is what you have, more or less:

SampleID | Date            | Outcome

1              | 2020-01-01 | 1

2              | 2020-01-01 | 0

3              | 2020-01-01 | 1

...

You get the idea. Now, the above is your fact table where you record all the outcomes at the lowest granularity. You also have to have a Date table that will join to Samples[Date]. Date is your date/time dimension. In this table you'll define all the pieces of time you want: months, years, weeks... you name it.

Now, here's a measure that will give you the % of passes/successes:

[Success Rate] = divide( sum( Samples[Outcome] ), countrows( Samples ) )

[Failure Rate] = 1 - [Success Rate]

And that's basically it. The column Outcome should store 0 for fail, 1 for success.