Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
Solved! Go to 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])
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])
Hello Ahmedx,
It worked for me, thank you so much.
Kind regards
Lukas
User | Count |
---|---|
141 | |
70 | |
70 | |
53 | |
53 |
User | Count |
---|---|
208 | |
95 | |
64 | |
61 | |
57 |