https://community.esri.com/t5/arcgis-for-power-bi-questions/cluster-summary-aggregates-color-fields-by-average/m-p/1220360#M1360 <P>Power BI Version: 2.109.1021.0 64-bit</P><P><SPAN class="">ArcGis for Power BI Version</SPAN><SPAN>: 2022.4.117</SPAN></P><P><SPAN>I added population data summarized as "sum" to the Color data field.</SPAN></P><P><SPAN>This has a relationship with post codes data which is added to the Location field.</SPAN></P><P><SPAN>On clustering I expect Cluster Summary to add up the population data. It instead does an average of all the points.</SPAN></P><P><SPAN>Is there a way to make the Cluster Summary "sum" the points rather than do an average?</SPAN></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="efejiroe_0-1665410347530.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/53237i7736B488EDC44343/image-size/medium?v=v2&amp;px=400" role="button" title="efejiroe_0-1665410347530.png" alt="efejiroe_0-1665410347530.png" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">efejiroe_0-1665410347530.png</span></span></P><P>&nbsp;</P> Mon, 10 Oct 2022 14:00:10 GMT efejiroe 2022-10-10T14:00:10Z https://community.esri.com/t5/arcgis-for-power-bi-questions/cluster-summary-aggregates-color-fields-by-average/m-p/1220360#M1360 <P>Power BI Version: 2.109.1021.0 64-bit</P><P><SPAN class="">ArcGis for Power BI Version</SPAN><SPAN>: 2022.4.117</SPAN></P><P><SPAN>I added population data summarized as "sum" to the Color data field.</SPAN></P><P><SPAN>This has a relationship with post codes data which is added to the Location field.</SPAN></P><P><SPAN>On clustering I expect Cluster Summary to add up the population data. It instead does an average of all the points.</SPAN></P><P><SPAN>Is there a way to make the Cluster Summary "sum" the points rather than do an average?</SPAN></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="efejiroe_0-1665410347530.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/53237i7736B488EDC44343/image-size/medium?v=v2&amp;px=400" role="button" title="efejiroe_0-1665410347530.png" alt="efejiroe_0-1665410347530.png" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">efejiroe_0-1665410347530.png</span></span></P><P>&nbsp;</P> Mon, 10 Oct 2022 14:00:10 GMT https://community.esri.com/t5/arcgis-for-power-bi-questions/cluster-summary-aggregates-color-fields-by-average/m-p/1220360#M1360 efejiroe 2022-10-10T14:00:10Z