Forum Discussion

Artemis1254's avatar
Artemis1254
Frequent Visitor
8 years ago
Solved

Filter out 0/Negative/Null values when calculating Median

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]...
  • Zubair_Muhammad's avatar
    8 years ago

    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]
        )