Forum Discussion
Comparing Values From Different Non-Related Tables
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
https://www.dropbox.com/s/k5fwlht3etpe6w1/Template%20Dashboard%20-%20Phone%20Records.pbix?dl=0
Yes. It is personal information but I've grab a limited section to give you a snapshot of the dashboard.
Basically I'm trying to create a heat map of call frequency to certain area codes. So I will need distinct count of area codes as well. I got stumped on the longitude/latitude before I got to that measure.