Attempting to break down sales by county---but keep getting duplicate value

[cwayne758]

Hi,

So I am trying to analyze sales by county-level (within the United States) but our datamart only drills down to City & State level. 

In order to get the County description, I imported a CSV file that includes all cities and counties by State within the United States.

When I go to merge the two queries inside of the Query Editor, all my values in FactSales end up getting duplicated, and the Expanded Column shows the incorrect county. 

 Duplicated Values(Huntsville, Alabama should show Limestone County)

Any suggestions as to how I can clean this up? My thought was to try to get zipcode info  for that particular sales record but wanted to try all workarounds before contacting IT. Not sure if that would even help.

Anyways, thanks in advance! 

[bherring1979 · Accepted solution]

Related Country = Related('Countries'[Country])

If you import that csv then make a relationship between the 'Sales'[City] and 'Countries'[City], you should be able to bring the country value into the data you're working with. You'll need to replace the names in quotes to your field names.

[bherring1979]

I wrote country in every one of those, but meant county...