Standard Deviation

[all4eph]

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.

[Greg_Deckler]

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.

[all4eph]

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

[Greg_Deckler · Accepted solution]

Well, I was thinking something like:

Ideal = AVERAGE([Ideal Concentration])

Ideal20%Above = [Ideal]*1.2

Ideal20%Below = [Ideal]*.8

[all4eph]

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

[Greg_Deckler]

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

[all4eph]

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

[all4eph]

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