Forum Discussion
Solved
Cpk DAX
Hi,
Need help to write DAX to calculate Cpk
Cpk formula
Sample data
current dax
Xbar = AVERAGE(Table[MeasureValue]) STDEV = STDEV.S(TableMeasureValue])
Abbreviations
USL= Limit Upper
LSL= Limit Lower
STDEV= sigma
Not entirely sure how you are using this, but perhaps something like:
Cpk = VAR CpU = (MAX([LimitUpper]) - [Xbar])/3*[STDEV] VAR CpL = ([Xbar] - MAX([LimitLower]))/3*[STDEV] RETURN MIN(CpU,CpL)
4 Replies
Not entirely sure how you are using this, but perhaps something like:
Cpk = VAR CpU = (MAX([LimitUpper]) - [Xbar])/3*[STDEV] VAR CpL = ([Xbar] - MAX([LimitLower]))/3*[STDEV] RETURN MIN(CpU,CpL)
Awesome and thanks alot.
PS. added a "( )" for ( 3*[STDEV] )
Cpk = VAR CpU = (MAX([LimitUpper]) - [Xbar])/(3*[STDEV]) VAR CpL = ([Xbar] - MAX([LimitLower]))/(3*[STDEV]) RETURN MIN(CpU;CpL)
vincentakatoh- I created a Quick Measure page for these kinds of process measures if you need any others or if you want to check that I didn't make any other mistakes!
