How to show summary values in map region?

[allenoneill]

Hi all,

I am trying to put aggregate values into a map in pretty much the same way as shown in the attached image...

I'm going around in circles trying to figure it out and would appreciate input from you experienced folk!

Stuff that I have available as input

* Irish County name  (also have lat/long available but reckon I don't need these as I am aggregating up to county level)

* Categories  (Rugby, Football, Athletics)

* Category values

example:

County	Rugby	Football	Athletics	Total
Dublin	100	50	25	175
Cork	50	80	10	140
Galway	70	120	30	220

I have tried pivoting it like this:

County	Category	Value
Dublin	Rugby	50
Dublin	Football	80
Dublin	Athletics	120
Cork	Rugby	50
Cork	Football	80
Cork	Athletics	10
Galway	Rugby	70
Galway	Football	120
Galway	Athletics	30

That seemed to get me further, but not quite right .... 

As per the attached image, I am trying to have a pie-chart appear in the county, that shows slices for each category value (or percentage)

Any assistance most gratefully received!

Allen.

Map regions showing category values/percentage in pie-chart

[v-chuncz-msft · Accepted solution]

@allenoneill,

You may drag measure below to Tooltips.

Measure =
CALCULATE ( SUM ( Table1[Value] ), ALLSELECTED ( Table1[Category] ) )