cancel
Showing results for
Did you mean:
Highlighted
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

Proud to be a Datanaut!

7 REPLIES 7
Super User IV

## Re: Standard Deviation

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

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

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

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

#### 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.

#### Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

#### Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!