Forum Discussion
Artemis1254
8 years agoFrequent Visitor
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]...
- 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] )
Zubair_Muhammad
Community Champion
8 years agoHi 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
8 years agoFrequent Visitor
Thank you so much. This works!