Forum Discussion

Regular Visitor

7 years ago

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

Well, I was thinking something like:

Ideal = AVERAGE([Ideal Concentration])

Ideal20%Above = [Ideal]*1.2

Ideal20%Below = [Ideal]*.8

7 Replies

Greg_Deckler
Community Champion
7 years ago
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
  Regular Visitor
  7 years ago
  thanks. to create a measure for this what fomular should i use to achieve the % line
  - Greg_Deckler
    Community Champion
    7 years ago
    Well, I was thinking something like:
    
    Ideal = AVERAGE([Ideal Concentration]) Ideal20%Above = [Ideal]*1.2 Ideal20%Below = [Ideal]*.8

Community Champion

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

Regular Visitor

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

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

Related content