Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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
Found
it is just (max+min)/2
Average is not a measure of center. Try Median.
Thanks
Both AVERAGEX and MEDIANX functions returns the same value in my case which is still lower than the value of "Center" in PowerBI.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.