topic Re: How PowerBI calculates these values in DAX Commands and Tips

How PowerBI calculates these values

Anonymous — Sat, 25 Mar 2023 11:47:12 GMT

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

Re: How PowerBI calculates these values

JW_van_Holst — Sat, 25 Mar 2023 13:10:22 GMT

Average is not a measure of center. Try Median.

Re: How PowerBI calculates these values

Anonymous — Sat, 25 Mar 2023 13:59:13 GMT

Thanks

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

Re: How PowerBI calculates these values

Anonymous — Sat, 25 Mar 2023 14:11:08 GMT

Found

it is just (max+min)/2