Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Thanks, I tried but since the calculated value was also in measures table[individual performance], it is not displaying when I write that query.
@Anonymous how you are raw data look like and what are your measures? and what is your expected output?
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |