Forum Discussion
Need help in Standard deviation
Hi, I have created two measures [Individual performance and Average performance - Weekly] or every user, i need to find how much deviation the correspnding user from the average. I have used the cl...
Hi Anonymous ,
You can use the following the measure like below:
Std Dev = STDEVX.P(FILTER(Table, Table[UserID] = MAX(Table[UserID]),[Individual Performance])
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
You should be able to use the following measure expression to get your result in whatever context (week, class, etc.), replacing Table for your actual table name.
Std Dev = STDEVX.P(Table, Table[Individual Performance])
Or you can use STDEVX.S.
Pat
Thanks, I tried but since the calculated value was also in measures table[individual performance], it is not displaying when I write that query.