Filter out 0/Negative/Null values when calculating Median

[Artemis1254]

Hi, I have a calculation for median that is built from this formula.

Median Latency Test =
VAR NumValuesHalved = COUNT ( Query2[Latency] ) / 2
RETURN
MINX (
FILTER (
VALUES ( Query2[Latency]),
CALCULATE (
COUNT ( Query2[Latency]),
Query2[Latency] <= EARLIER ( Query2[Latency] )
)
< NumValuesHalved
),
Query2[Latency]
)

I am wondering how to alter this formula to filter out 0/negative/null values so that they are  not utilized in the calculation of Median Latency. Can anyone help with this?

[Zubair_Muhammad · Accepted solution]

Hi @Artemis1254

Give this a try

Median Latency Test =
VAR NumValuesHalved =
    COUNT ( Query2[Latency] ) / 2
RETURN
    MINX (
        FILTER (
            VALUES ( Query2[Latency] ),
            Query2[Latency] > 0
                && CALCULATE (
                    COUNT ( Query2[Latency] ),
                    Query2[Latency] <= EARLIER ( Query2[Latency] )
                )
                    < NumValuesHalved
        ),
        Query2[Latency]
    )

[Artemis1254]

Thank you so much. This works!