Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
Need Help
  • v-deddai1-msft's avatar
    v-deddai1-msft
    5 years ago

    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

     

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks, I tried but since the calculated value was also in measures table[individual performance], it is not displaying when I write that query.