Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

How PowerBI calculates these values

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...
Color Map
Shape Map
JW_van_Holst's avatar
JW_van_Holst
Icon for Resolver IV rankResolver IV
3 years ago

Average is not a measure of center. Try Median.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thanks

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