Map location and size - size by measure?

[Bokazoit]

I have this measure:

ColdSpotClm = IF([Delivered hours] > 18 && [UsedPercent]<0,6;"Big";IF([Delivered hours] >= 6 && [Delivered hours]<=18 && [UsedPercent]<0,5;"Medium";IF[Delivered hours] >= 3 && [Delivered hours]<= 5 && [UsedPercent]<0,4;"Small";"")))

[Delieverd hours] and [UsedPercent] is a measure too:

[Delieverd hours] = SUM('HotSpotAnalyse'[Delievered])+IF(SletParam[Parameter Value] = 1;SUM('HotSpotAnalyse'[Deleted]);0)

[UsedPercent]= SUM('HotSpotAnalyse'[Used])/(SUM('HotSpotAnalyse'[Delievered])+IF(SletParam[Parameter Value] = 1;SUM('HotSpotAnalyse'[Deleted]);0))

I would like to use that measure as Size of bubbles on the Map, how to do that?

In my query I can create the case when statement and say like:

Case when ... then 1 else 0 end

and then Sum, but now that I use several periodes I need Power BI to calculate it for me and I can not seem to find a solution 😞

[v-cherch-msft]

Hi @Bokazoit

It seems you need to drag the measure to 'Size'. Here are the articles to see if these are helpful. If it is not your case, please share some simplified data sample and expected output. You can upload it to OneDrive or Dropbox and post the link here.

https://powerbi.tips/2016/04/mapping-in-pbi-desktop/

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-map-tips-and-tricks

Regards,

Cherie