Forum Discussion

clem312's avatar
clem312
Resolver I
4 years ago
Solved

Standard deviation

Hi everyone,

 

I am trying to calculate a standard deviation, counting the number of Code per ID :

M1 is my average.

D1 is the number of code for each ID.

VAR M1 = DIVIDE(CALCULATE(COUNT([Code]), year=2020, Brand=A), CALCULATE(DISTINCTCOUNT([ID]), year=2020, Brand="A"))
VAR D1 = CALCULATE(COUNTX(VALUES([ID]), CALCULATE(COUNT([Code]), year=2020, Brand="A")))
 
D1-M1 should be my standard deviation
But I must do something wrong...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, clem312 ;

    You could use STDEVX.S 、STDEVX.P、 STDEV.P、STDEV.S

    to calculate the standard deviation .If not, can you share your simple data and desired results?

    Best Regards,
    Community Support Team_ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

1 Reply

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Community Support
    4 years ago

    Hi, clem312 ;

    You could use STDEVX.S 、STDEVX.P、 STDEV.P、STDEV.S

    to calculate the standard deviation .If not, can you share your simple data and desired results?

    Best Regards,
    Community Support Team_ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.