Need help in Standard deviation

[Anonymous]

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. 

[v-deddai1-msft · Accepted solution]

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]

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]

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

[parry2k]

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

[Anonymous]

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