Forum Discussion
Comparing Values From Different Non-Related Tables
Hi Anonymous
If I understand correctly what you need, you could try this:
Create a relationship between both tables through the Area Code (Many-to-one, the table with the coordinates on the many side)
You can then bring the longitude and latitude into your cell records table with RELATED( ):
LongitudeColumn = RELATED(TableCoordinates[Longitude])
LatitudeColumn = RELATED(TableCoordinates[Latitude])
It's not letting me relate the tables Many to One. " The cardinality you selected isn't valid for this relationship." The only selection it lets me accept is many to many but when I go to use the RELATED(): it will not let assign a column or table.
Can you think of a non-relationship DAX for this?
Anonymous
That's weird. Are the area codes in your Longitude/Latitude table not unique? They should. Would it be possible to eliminate the duplicates in that table? Otherwise we'll face issues with other approaches as well.
Yeah, Area Codes are not great when it comes to location based plotting. For example Area Codes for Key West, Florida are 305 & 786 and they both have the same latitude & longitude. It may not be possible since a majority of my calls are in the Dallas area which has three area codes that serve the same coordinates. I wonder if I should find like values are just barely change them so that they are unique like 32.78306, 32.78307, 32.78308. It might slightly throw off my coordinates but by how much?
Or maybe look for a better area code data source.
Anonymous
Ok but you seem to be saying that what is not unique is the longitude and latitude. That should not matter. If the area codes in your Longitude/Latitude table are unique we're fine. Are they?
Can you share the pbix? That would make things faster
Or if you have sensitive info maybe just a pbix with the two tables involved that we are discussing