October 28 & 29: Experts share their secrets on how to pass the Fabric Analytics Engineer certification exam—live. Learn more
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
Solved! Go to Solution.
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)
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!
Yeah, I actually added those too after my post I was looking at the formulas and thinking, hmmm...I think it needs some parens... 🙂
User | Count |
---|---|
105 | |
99 | |
98 | |
86 | |
49 |
User | Count |
---|---|
162 | |
142 | |
132 | |
102 | |
63 |