cancel
Showing results for
Did you mean:
Frequent Visitor

## 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 concentrataion(ideal concentration varies from 2-2000 in no particular order) and also having the ideal concentration line constant on the gragh when ever an ideal concentration is selected from the slicer. below is a sample of my data which as the calculated concentration on the y axis and the sample on the x axis.

1 ACCEPTED SOLUTION

Accepted Solutions
Super User IV

## Re: Standard Deviation

Well, I was thinking something like:

```Ideal = AVERAGE([Ideal Concentration])

Ideal20%Above = [Ideal]*1.2

Ideal20%Below = [Ideal]*.8```

### I have book! Learn Power BI from Packt

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

7 REPLIES 7
Super User IV

## Re: Standard Deviation

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

### I have book! Learn Power BI from Packt

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Frequent Visitor

## Re: Standard Deviation

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

Frequent Visitor

## Re: Standard Deviation

hello please see sample data as requested 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_090118_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
Super User IV

## Re: Standard Deviation

Well, I can imagine a measure that uses HASONEVALUE and if so, displays the AVERAGE, MAX or MIN of Ideal Concentration. You could then have 2 additional measures for 20% above and 30% below, or whatever, of this measure. Then you just display then in the line chart and they would come out as constant lines.

### I have book! Learn Power BI from Packt

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Frequent Visitor

## Re: Standard Deviation

thanks. to create  a measure for this what fomular should i use to achieve the % line

Super User IV

## Re: Standard Deviation

Well, I was thinking something like:

```Ideal = AVERAGE([Ideal Concentration])

Ideal20%Above = [Ideal]*1.2

Ideal20%Below = [Ideal]*.8```

### I have book! Learn Power BI from Packt

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Frequent Visitor

## Re: Standard Deviation

thank you so much for the answer, i also have a situation that i would like to implement a flag if any of the sample concentration exceeds 30% above and 30% below an email should be sent notifying me of the sample that is out of range. thanks you

Announcements

#### Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

#### Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

#### January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

#### Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors