Normalized area map

Hi Anonymous

So here is what I've done with your data : 

I've created Table1

ID	EventID	Country
1	12334	USA
2	5678	Italy
3	9545	USA
4	4585	France

And Table2

Country	Population
USA	360000000
Italy	60000000
France	67000000

They have a bidirectionnal filter between them

Then I create a calculated Table3

Table3 = SUMMARIZE(table1;Table1[Country];"Number of events"; counta(Table1[EventID]);"Event/Person";Divide(counta(Table1[EventID]);sum(Table2[Population])))

And add a bidirectionnal filter between Table2 and Table3

Then I add a map and here what It looks like : 

USA is more faded because it has more inhabitants than France and Italy (both of these country have between 60 and 70 M inhabitants so the color is almost the same)

You need to add Event/Person in the saturation color field and then add Number of Events in the tooltip area (the bottom one called Info-bulles on my screen) so that the end-user can still have it.

- Quentin