Custom labels for combined geographies in map

[mahmad]

Hello,

I have data for countries that I'm combining into a mega region, which I then map to a location of my choosing.

E.g. In the location expression, I combined all country-level records like US and Canada into a North America value that is mapped on the US:

=If([Country]='US', 'US',
If([Country]='Canada', 'US',
[Country]))

I chose the US as a location for the combined measure, which is sum(population). How can I label this one aggregated bubble that I mapped to the US location, but has data for both US and Canada, as North America?

I tried using this formula for the label:

=If([Country]='US', 'North America',
If([Country]='Canada', 'North America',
[Country]))

This doesn't work - I'm guessing because mapped point is a sum of different countries and this formula won't work.

Any help is appreciated! 

[lorenzoconforti]

Not really sure I understand what you are trying to achieve. Can you post a sample dashboard? it would be easier to help you