Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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... 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |