topic Re: Median of Median on TimeSeries in DAX Commands and Tips

Median of Median on TimeSeries

Anonymous — Thu, 20 Oct 2022 09:50:31 GMT

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

Re: Median of Median on TimeSeries

daXtreme — Thu, 20 Oct 2022 11:56:22 GMT

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

Re: Median of Median on TimeSeries

Anonymous — Thu, 20 Oct 2022 12:14:30 GMT

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