How PowerBI calculates these values

[Anonymous]

Hi all;

I wanted to know how the minimum, center, maximum value is calculated by the PowerBI. I am using Shape map and wanted to how it is calculated because I want to compare my calculation. The minimum and maximum mataches but the center is not matching my calculation (averagx).

Thanks

[Anonymous]

Found

it is just (max+min)/2

[JW_van_Holst]

Average is not a measure of center. Try Median.

[Anonymous]

Thanks

Both AVERAGEX and MEDIANX functions returns the same value in my case which is still lower than the value of "Center" in PowerBI.