Standard deviation

[clem312]

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

[v-yalanwu-msft · Accepted solution]

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.