Calculate Median in a Row with Measures

[WasmerL]

Hello Community,

I am currently struggling with the calculation of the median in a table. This table contains 10 columns, each with a measure containing a time value in seconds. I would like to calculate the median over the individual measures.

Basically I want something like this:

MedianAllMeasures =
MEDIANX(
'_Measures',
[Part 1] + [Part 2] + [Part 3] + [Part 4] + [Part 5] + [Part 6] + [Part 7] + [Part 8] + [Part 9] + [Part 10].

However, this approach does not work.

I ask for your help. Thank you very much.

Below is a screenshot of the data.

[Ahmedx · Accepted solution]

pls try this

MedianAllMeasures = 
   VAR _tbl ={
               [Part 1] , [Part 2] , [Part 3] , 
               [Part 4] , [Part 5] , [Part 6] , 
               [Part 7] , [Part 8], [Part 9] , 
               [Part 10]
       }
RETURN
MEDIANX( _tbl,[VALUE])

[WasmerL]

Hello Ahmedx, 

It worked for me, thank you so much. 

Kind regards 
Lukas