Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
82 | |
74 | |
66 |
User | Count |
---|---|
121 | |
105 | |
102 | |
82 | |
72 |