[DAX] Measure with SUM of ABS function

[MKPartner]

Hello, 

I have a project to calculate process capablity & I wonder how to calculate standard deviation wthin with DAX using. I know how to do it in excel. 

The process looks like this. I have all the results in one column. Resutls are filtered by at least two slicers. When data are filtered, I need to calculate average which is counted like SUM of ABS function from substraction of two cells (cell A - cell B, cell B - cell C, cell C - cell D & until end of range & divided by number of case - 1.

Is it that possible to count this with DAX in Power Bi ?   

[Vijay_A_Verma · Accepted solution]

There are already VAR.S and VARX.S functions to do this in DAX (for population VAR.P and VARX.P) on the lines of variance functions in Excel.