Using a Scatter Plot Chart over a map

[Anonymous]

Hello everyone,

I have the two tables below :

Table 1

ID	...	Place	...	...
1	...	place1	...	...
2	...	place2	...	...
3	...	place1	...	...
4	...	place3	...	...
5	...	place1	...	...

Table2

Place	position x	position y	occurences
place1	...	...	3
place2	...	...	1
place3	...	...	1

I want to achieve a scatter plot, over a map. The x,y position of a dot is artificially given and corresponds to the grid position over my map (so the dot is over the correct place).

I can't seem to find the formula to go in the column "occurences" so it returns the total number of rows in table 1 that match the place. 

I can't seem to figure out what fields to put where on my Scatter Plot Chart settngs so it shows what I want to achieve.

To me there is 2 ways of doing it and I can't seem to figure them out :

1) Create a column "occurences" (shown in red) so all the data i need for my scatter plot is in the same table.

2) Connect with a relationship Table1 and Table2 (which relationship ?)

I need help figuring out to set up the scatter plot. Please show screenshots of how you set it up ; I can't find myself 😞

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523