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

     

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