Plotting Latitude and Longitude on Map that are calculated via DAX measures

[Anonymous]

Hi all,

I have calculated "average" latitude and longitude coordinates by converting them from decimal coordinates(lat/lon) -> to cartesian coorinates (x, y, z) -> and back to decimal coordinates (lat/lon). However, when attempting to plot them onto the map visualisation, I get this error message:

"Can't display this visual.
To display latitude and longitude pairs, set the aggregate for Latitude and Longitude to Don't summarize."

However, since they are measures, I do not have any option to set them to "Don't summarize". How can I plot these points?

@Greg_Deckler @koorosh 

[Greg_Deckler]

@Anonymous IDK, not sure if I ever tried using measures for map locations before. Perhaps you could try creating a calculated table? Seems like a bug to me. Measure, by definition, can only return a single, scalar value so seems like it should work as long as you have something in the Legend that uniquely identifies each point.

[Anonymous]

Hi @Greg_Deckler, sorry for late reply. The limitation of what i'm trying to do requires the map coordinates as calculated measures, which makes it tricky. I found a round-about way to do it without having it as measures (less accurate, but fits ~80% of the requirement) and it was good enough for me.
 

Thanks for your comment!