Using Standard Deviation

[jonnyA]

Hello,

I am looking to add a 10% threshhold for any provider 10% above or below the Group Average.  Ive never used Standard Deveation, but I believe that is what I need to use here.  In the matrix in the screen shot we have Rows: "Provider Name".  Columns: HCPCS_CS.  Values: Voucher #, aka "Visits" shown as Count Distinct.  Then we have CPT_Code, aka "Provider %", shown as Count, shown as Percent of Row Total.  Then we have "Group Average (Ignore Degree)" aka "Group %", shown as Percent of Grand total.  Finally, we have National %, aka  "National Average", shown as Percent of Grand Total.  

I have included all of the fields.  If there is anything else the experts know please let me know and I will get that for you!  Thank you in advance! 

[Anonymous · Accepted solution]

@jonnyA 
Please follow Standard Deviation in Power BI | Dash-Intel.

Or just follow this tutorial video:
Standard Deviation in Power BI | How to create measures for SD, Mean and Upper/Lower Limits - YouTub...

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.