Forum Discussion
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 concentrata...
Well, I was thinking something like:
Ideal = AVERAGE([Ideal Concentration]) Ideal20%Above = [Ideal]*1.2 Ideal20%Below = [Ideal]*.8
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.