Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Benchmark Average +/- 10%

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.
 
 
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous ,

    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

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous ,

    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