Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi
i'm trying to show density of "people" events per region and it works perfectly fine. The issue however is that these events are not normalized with the density of the population with the region. So for example I have a lot of events in highly populated areas, while few in lower populated - but it might be that we have more events compared to the population.
I have two tables:
Data table: one row per event, with region as a column
Density table: one row per region, with the population in that region as a column
I can easily show the map, but how do I show the normalized map?
Solved! Go to Solution.
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
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |