Forum Discussion
Solved
Standard Deviation
hello, am new to power BI, and am trying to plot a levey jenning standard deviation chart on power BI, that shows a minimum of 20% and max of 30% deviation from both ends of the ideal concentrata...
Well, I was thinking something like:
Ideal = AVERAGE([Ideal Concentration]) Ideal20%Above = [Ideal]*1.2 Ideal20%Below = [Ideal]*.8
Can you paste that sample data as text? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
please see sample data below, hope that works. thanks
| SampleConcentration | Analyte | CalculatedConcentration | PercentageDiviation | MachineName | TestDate | IdealConcentration |
| A_090118_POS_QC_50 | Lamotrigine | 37.0688 | -25.8623 | APOLLO_POSQC_090118 | 9/7/2018 | 50 |
| A_091118_POS_QC_50 | Fluoxetine metabolite | 119.024 | 138.047 | APOLLO_POSQC_091118 | 9/11/2018 | 50 |
| C_090518_POSCAL_1000 | Doxepin | 1015.36 | 1.53557 | GALACTUS_POSCAL_090518 | 9/10/2018 | 1000 |
| B_091118_POSCAL_50 | Hydrocodone | 51.3164 | 2.63289 | BRYNHILDR_POSCAL_091118 | 9/11/2018 | 50 |