Standard Deviation of actions posted

[Anonymous]

Hello Power BI Experts,

I am trying too creating a control chart using standard deviation to calculate UCL / LCL means @(3, 2, 1) levels (see table below).  Lacking the appropriate DAX coding experience I am having trouble producing the results expected.

Any help would be greatly appreciated.

Thank you,

Week	2018	Average	STDEV	UCL*3	LCL*3	UCL*2	LCL*2	UCL*1	LCL*1
1	66.0	63.5
2	74.0	63.5
3	51.0	63.5
4	62.0	63.5
5	64.0	63.5
6	73.0	63.5
7	64.0	63.5
8	54.0	63.5
9	76.0	63.5
10	60.0	63.5
11	63.0	63.5
12	55.0	63.5

[v-lili6-msft]

hi @Anonymous 

You could use STDEV.P Function to create a measure for it.

and you could also have a look at this post:

https://community.powerbi.com/t5/Desktop/Control-Chart-UCL-LCL-of-Rejected-Category/m-p/812867

Regards,

Lin

[Anonymous]

Lin,

Using the Standard Deviation syntax below how would I adjust the DAX command to fit my original query?

Std Dev = CALCULATE(STDEVX.P('Calendar',[Total Sales]), ALLSELECTED('Calendar'))

[Anonymous]

Hello Lin, thank you for responding to my query -

I am still confused and my be missing something; the other solution does not highlight how one would calculate Standard Deviation and in turn calculate 1, 2, or 3 sigma control limits?

Thank you