Median of Median on TimeSeries

[Anonymous]

Dear Community

I'm created a MEDIAN measure for salesPrice. 

As you can see on my screenshot, the blue line is the result I currently get.

But what I like to get is the Median based on the selected date range.

That would be 53.67 in my example, because this is the middle value (median) of this three numbers.

I tried the followning meaure but I don't work as expected.

Test_Medain =
Var Var_LastDate  = Max('Time'[DateKey])
Var Var_FirstDate = Min('Time'[DateKey])
Var x =
CALCULATE(
    MEDIAN(OrderLine[SalesPriceEUR])
    ,Filter(
         ALL('Time')
        ,AND('Time'[DateKey] >= Var_FirstDate ,
             'Time'[DateKey] <= Var_LastDate
        )
    )
)
Return (x)    

Any plans how I must modify my query?

Thx 

[daXtreme · Accepted solution]

Please adjust the measure MyMedian to your needs. File attached.

[Anonymous]

This Statement works totally fine for me.
Many, many thanks.

Var SalesPrice = Sum(Sales[SalePrice])

Var v_X_Axis_SelectedTime = ISFILTERED('Time'[DateValue])

Var v_Result =

    IF(v_X_Axis_selectedTime,

        MEDIANX(

            ALLSELECTED('Time'),[SalesPrice]

        )

    )

Return

    v_Result