SPC Charts how to calculte the UCL and LCL

[udaykiranboppan]

Hi,

I am trying to create a SPC chart, I have calculated the Average sales, but the Standard Decviation is showing 0 and hence the UCL and LCL are showing the same values.

Could someone please help me in this regard.

Link to PBIX - https://drive.google.com/file/d/11PrLUOHrL-r_wO-_NzTjlTVcGCrqaskZ/view?usp=sharing

Many Thanks,

Uday

[Bubble4502]

Hi @udaykiranboppan ,

According to my knowledge, this may caused by Allselected(), please try to use a new measure like this to replace StdDev

StdDev = CALCULATE(STDEVX.P(Sales,'Dimensions'[No of Sales]),FILTER( ALL('Table'),[YearMonthShort]=MAX(YearMonthShort))

Kind Regards,

Bubble

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.