How do you use the Average line results created in from the analytic tab in a calculation?

[Anonymous]

I have created a Area line chart and included an average line which works great. What I want to do now is include a calculation that will take the results of the average line witch will create another line that will represent the % difference for average.

I can manualy include the number in the calculation but the data it going to change based on the filtering therefor the average will also change.

This is the calculation I am using.

Case_Count % difference from SLR-06 =

VAR __BASELINE_VALUE = 2357

VAR __MEASURE_VALUE = SUM('SLRCaseData'[Case_Count])

RETURN

    IF(

        NOT ISBLANK(__MEASURE_VALUE),

        DIVIDE(__MEASURE_VALUE - __BASELINE_VALUE, __BASELINE_VALUE)

    )

[Ashish_Mathur]

Hi,

Replace 2357 by the measure you have written.