Forum Discussion

MKPartner's avatar
MKPartner
Icon for Helper II rankHelper II
4 years ago
Solved

[DAX] Measure with SUM of ABS function

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 ?   

  • 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. 

1 Reply

  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    Icon for Most Valuable Professional rankMost Valuable Professional

    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.