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

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