Combine column entries and count into single calculated column to enable labelling on Bubble Map

[Anonymous]

Hi all, 

I have a map with various locations on it - e.g.:

UK	Dave
France	Gill
Spain	Francis
UK	Moira
Finland	Han

(it goes on for longer...)

And I'd like to label the bubble map with more than just the country name when I use it as a location, so thought that I could combine the country name and a count of the country name into a single calcuated column so the end result would be

UK 2

France 1

Spain 1

Finland 1

And I could then combine these into the single field that I could use as location so that the data labels would read "UK: 2" as opposed to just "UK".

I feel like I am missing an obvious trick here and being dim, but any guidance would be appreciated.  

[Anonymous · Accepted solution]

Sorry for the slow reply, I had issues logging in.

I wanted to data to be displayed on the map without requiring a tooltip (so I could capture the image and share it and not lose the info), so I needed a calculated column:

BubbleCount = 'Table'[Country]&" : "&CALCULATE(COUNT('Table'[Country]), ALLEXCEPT('Table', 'Table'[Country]))

Which works! It did however cause an issue with some countries randomly being put in the wrong place, but I can work around that. Seems odd to not have this kind of feature (more detailed labelling) as standard in PowerBI. 

[jgeddes]

If you create the measure

Formatted Country Measure =

var _count =

CALCULATE(COUNT(countryTable[Country]), ALLEXCEPT(countryTable,countryTable[Country]))

Return

SELECTEDVALUE(countryTable[Country]) & ": " & _count

and place it into the tooltips field you will end up with the result

If you want just the formatted measure as the tooltip you can get that using a custom tooltip page.

Quickly the result would be

But once you get into custom tooltips there are plenty of options available to make the tooltip look/say what you want.