Hi,

Yes it can be done in measure, and i have one suggestion:

1. You can use standard MEDIAN() DAX formula

MEDIAN_NEW:=MEDIAN(Tabela1[Average])

2. Now the calculation looks like this:

Above MEDIAN:=

VAR

MEDIANCALC = [MEDIAN_NEW]

RETURN

SUMX(Tabela1; (Tabela1[Average]>MEDIANCALC)*1)

Variables are used to avoid using allexcept() in median calculations

## Like this thread? Share it with others