Trying to Calculate Standard Deviation
Hello All, I am trying to calculate standard deviation and most of what I have found on the internet is based on columns in a table and I am struggling with how to write a DAX formula for use with an analysis server where the data pulls from. I have used this link as a basis and have made some strides in calculating the SUM and the Avg. In the screenshot below I have the table in which I selected a range of weeks and Repeat Dispatches in whcih I am trying to plot standard deviation for. For SUM I used the formula: *RDR SUM = CALCULATE(SUMX(VALUES('Dim - Calendar'[Fiscal Week]),([Repeat Dispatch 7 day Numerator]/[Repeat Dispatch Denominator])), ALLSELECTED('Dim - Calendar'[Fiscal Week])) For Avg I used the formula: *RDR Avg = CALCULATE(DIVIDE([Repeat Dispatch 7 day Numerator],[Repeat Dispatch Denominator]), ALLSELECTED('Dim - Calendar')) For Standard deviation I cannot quite find how to use the previous calculations to find standard deviation which should be .0266 based on the calculations I found with an online calculator. Any help would be appreciated. Dave
