Benchmark Average +/- 10%

[Niiru1]

Does anyone know how to get a straight line average for a measure?

I have been using this measure on a line and stakced column chart for school tests with AppointmentDate[Date] as my x-axis and 

[Test Conducted Pass %] as my Y-axis.

Tests Conducted Pass % = [Tests Conducted Pass]/[Tests Conducted]

I know I can get the average from the analytics pane but is it possible to get the straight line overall average in a measure and possibly 2 others to show +10% and -10%?

e.g.

[amitchandak · Accepted solution]

@Niiru1 ,

Create measures like
upper= calculate([Tests Conducted Pass]/[Tests Conducted], allselected()) * 1.1

lower= calculate([Tests Conducted Pass]/[Tests Conducted], allselected()) * 1.1

Use then in y axis constant line (under Analytic pane in visualization) , You have fx option to use measures