How to use Map Visual with Calculated Latitude and longitude

[Stephane_SFE]

Hi

I'm currently struggling with the map visual and GPS coordinate.

I have sales data for accounts, and I want to calculate the Economic center of gravity of my territories ("Secteur").

So, for that I’ve created:

• The sales measure: Sales_CA = SUM(Sales_Account[CA])     "CA"
• The latitude of the Economic center of gravity:
  • Latitude_vs_CA_total = [Sales_CA]*SUM(Accounts [Latitude])
  • Barycentre_Eco_Latitude = DIVIDE(SUMX( Accounts,[ Latitude_vs_CA_total]),[Sales_CA])  "Bary Lat"
• The longitude of the Economic center of gravity:
  • Longitude_vs_CA_total = [Sales_CA]*SUM(Accounts [Longitude])
  • Barycentre_Eco_Longitude = DIVIDE(SUMX( Accounts,[ Longitude_vs_CA_total]),[Sales_CA]) "Bary Long"

When I create a table, all is fine:

But when I want to use it in the map, I have an issue. Due the fact the measure needs the ‘don’t summarize’ option but I can’t.

What is the best thing to do to solve it ?

Many thanks for the help.

Regards

[AlanRGroskreutz]

I ended up using the Icon Map custom visual from the AppSource.  Works great.

[AlanRGroskreutz]

l'm also having this issue.  Replying here to get this moved back up the list.   I have created a Calculated Measure for my Lat & Lon based on an if statement so one of them can be moveable.

[fhill]

Replying here to get this moved back up the list.  I'm having simular issues.  I have created a Calculated Measure for my Lat & Lon based on weighted location data.  But I can't map the Measure values?

[Idrissshatila]

Hello @Stephane_SFE,

You should format the columns as latitude and longitude, refer to the ling for instructions

https://radacad.com/how-to-do-power-bi-mapping-with-latitude-and-longitude-only

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[Stephane_SFE]

Hi

Thanks for the answer but it's not columns but measures and they are already tag as Latitude and Longitude.