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

---------------------------------------

Not the Power BI thought police...

##### I have NEW book! DAX Cookbook from Packt
Over 120 DAX Recipes!

Proud to be a Datanaut!

7 REPLIES 7
Super User IV

## Re: Standard Deviation

---------------------------------------

Not the Power BI thought police...

##### I have NEW book! DAX Cookbook from Packt
Over 120 DAX Recipes!

Proud to be a Datanaut!

Regular 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

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

---------------------------------------

Not the Power BI thought police...

##### I have NEW book! DAX Cookbook from Packt
Over 120 DAX Recipes!

Proud to be a Datanaut!

Regular Visitor

## Re: Standard Deviation

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

Highlighted
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

---------------------------------------

Not the Power BI thought police...

##### I have NEW book! DAX Cookbook from Packt
Over 120 DAX Recipes!

Proud to be a Datanaut!

Regular 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

#### New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

#### ‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

#### Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

#### Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

#### Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors