Forum Discussion

vincentakatoh's avatar
vincentakatoh
Helper IV
8 years ago
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 ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    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)

     

     

vincentakatoh's avatar
vincentakatoh
Helper IV
8 years ago

Greg_Deckler, 

 

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)
Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

Yeah, I actually added those too after my post I was looking at the formulas and thinking, hmmm...I think it needs some parens... :)