Power BI地图不同地域粒度的经纬度计算

longitude = 
// 经度
SWITCH(TRUE(),
    ISINSCOPE('erp_district'[district_name]), AVERAGE('erp_district'[longitude]),
    ISINSCOPE('erp_region'[biz_area_name]), AVERAGE('erp_region'[longitude]),
    AVERAGE('erp_community'[longitude])
)

latitude = 
// 纬度
SWITCH(TRUE(),
    ISINSCOPE('erp_district'[district_name]), AVERAGE('erp_district'[latitude]),
    ISINSCOPE('erp_region'[biz_area_name]), AVERAGE('erp_region'[latitude]),
    AVERAGE('erp_community'[latitude])
)