Help needed to calculate median based on a measure

[ephramz]

I'm encountering this problem whereby I have a measure that calculates the Actual Time, based on equipment number and operation number in the matrix table visual ontop.

I created another table visualization at the bottom and I wish to have a measure that calculates the median of these 'Actual Time Values' without counting/ignoring cells that contains the value 0

Currently my dax function for this median measure is as follows:

Median = MEDIANX(SUMMARIZE('ENGG VW_TRM','ENGG VW_TRM'[Op. No.],'ENGG VW_TRM'[Equipment]),[Actual Time])

However, this measure includes all the cells that contains the value 0 

How can I work around this.

Help is really appreciated. Thanks all 

Regards,

Ephram

[amitchandak · Accepted solution]

@ephramz , Try like

if [Actual Time] is a column

Median = MEDIANX(SUMMARIZE(filter('ENGG VW_TRM',[Actual Time] <>0 ),'ENGG VW_TRM'[Op. No.],'ENGG VW_TRM'[Equipment], "_1", sum([Actual Time]) ),[_1])

if [Actual Time] is a measure

Median = MEDIANX(filter(SUMMARIZE('ENGG VW_TRM','ENGG VW_TRM'[Op. No.],'ENGG VW_TRM'[Equipment],"_1",[Actual Time]), [_1]<>0),[_1])