Error Reading Meaning?

Hello all, 

I have a dashboard of data that I update twice a year with the same data metrics from the previous 6 months. This time, when I appended my new data to the cumulative dataset, some of the location data or relationships aren't working. 

Example: I have cards on the dashboard that show: 

1. Total Count of Sales (Cumulative Total) 

2. Total Sum of Sales (Cumulative Total) 

3. Total Count of Sales [in Specific Geogrpahy] (Cumlative Total)

4. Total Sum of Sales [in Specific Geography] (Cumulative Total). 

I have metrics of state and county, with a relationship to another data table of county, state that qualifies as a "specfiic geography." I then have a merged column that combined the "county" and "state" into one so it can filter as a "Yes" or "no" for the speicifc geography, and measures to calculate the count and amount of of the new cumulative totals. 

For this round, someting isn't working. It added the new data to the total count and total sum of sales, but the specific georgraphies are the same as last time (not connecting to the new data, which I know has sales in specific geographies that aren't being recognized). 

The following error came up when using the same measures and calculations as last time: 

MdxScript(Model), (7,7) Calculation Error in Measure "geogrpahy table name"[specific values]: The funciton SUMX cannot work with the values of type String.

I should also mention that the merged column I recreated to incorporate the newly appended data now doesn't show all of my cumulative data, as it's misising a lot of state and county data that is in the individual data sets, but is not showing up in the appended cumulative table. 

Any and all help would be greatly appreciated, and lessons on what I did wrong to avoid this again would be also appreciated. 

Thanks in advance!