Problem with Custom Map Visual

[userpowerbiii12]

I'm working with map visual in Power BI to show the number of employees per city when I filter by country, everything works perfectly fine. For instance , when I choose country london, my map is perfectly zoomed at the country and displaying the return value of my measure per state.

This is my measure to count the number of employees per workplace:

Employees Per Workplace = CALCULATE( DISTINCTCOUNT(FACT_TABLE[FK_EMPLOYEE]), USERELATIONSHIP(FACT_TABLE[FK_EMPLOYEE], DIM_EMPLOYEE[ID_EMPLOYEE]), USERELATIONSHIP(FACT_TABLE[FK_WORKPLACE_REGION], DIM_WORKPLACEREGION[REGION_ID]))

Now, I actually found another beautiful and interesting visual using the custom map from this Youtube tutorial.

https://www.youtube.com/watch?v=OQuKwy6eEDk

I actually downloaded the JSON file and I noticed that it only has names of countries. In the youtube example, when it filters by continent , it shows the distribution of a measure (Percentage of population) and works correctly. However for my case, I'll be filtering by country, and I'll be seeing for each city of the selected country how many employees do I have. Except that when I filter , it's not showing anything. The only case that it shows is when I choose "Luxembourg" which is the name of a country but also the name of a state/city.

I even tried to add longitude and latitude in my dataset and set them to the respective categories. I also set the country and city (which I have in 2 separate dimensions) to the respective categories

**So I don't know If the issue could be with the JSON file I'm using ? **

Here's the link to PBIX file: https://drive.google.com/file/d/1VqiLlilSkNzBX5Y6S-Hsr1N2zApVci7k/view?usp=sharing

Here's the JSON file: https://pastebin.com/wQTprvyX

[lbendlin]

Please note that "city"  and "country"  are different things.  Clean up your data.

[lbendlin]

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

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[userpowerbiii12]

hello @lbendlin i just put the drive link to the PBIX file & the JSON file. Feel free to Check it out when you can. Appreciative for your help 🙂