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 clicer for the user id. Please find the attached picture for reference. Since both are calculated measures it is really hard to find the standard deviation. Can anyone help me please. 

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

     

5 Replies

  • parry2k's avatar
    parry2k
    Super User
    5 years ago

    Anonymous how you are raw data look like and what are your measures? and what is your expected output?

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi,

      Thanks for the reply, actually my raw data had the date/time field, user id, and actions performed (view, create, start) so i converted the date into week and took count of actions for every week for every user along with the average. I am expecting a output that shows how much away the student performance from mean, for that I need standard deviation

       

       

  • mahoneypat's avatar
    mahoneypat
    Microsoft 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.

  • v-deddai1-msft's avatar
    v-deddai1-msft
    Community Support
    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