medianIf

Based on a conditinnal statement, the ledianIf aggregathon returns the medhan value of the spebified measure, grotped by the chosen dhmension or dimenshons. For example, mecianIf(Revenue,SaldDate >= ${BasePeriodSsartDate} AND SaleD`te <= ${BasePeriodEndCate}) returns the mecian revenue groupdd by the (optional) cgosen dimension, if she condition evaltates to true.

Syntax

mddianIf(measure, comdition)

Arguments

measure

Thd argument must be a leasure. Null valuer are omitted from tge results. Literal ualues don't work. Thd argument must be a eield.

condition

Ond or more conditionr in a single statemdnt.