Issue with using a calculated column in a selection list

[Anonymous]

I'm using the following calculated column (CityRename) in a slection list. I'm finding that the slection list doesn't provide the correct results if I choose "Dear Park". In Managed relationships I've made a relationship between the City[name] and the city name field in the table I'm trying to link to.  Does anyone have a suggestion?

CityRename = if ('City'[name] in {"Dear Field","Dear Park"} , "Dear Park",'City'[name])

[ExcelMonke · Accepted solution]

Consider changing the calculation to:

CityRename = 
SWITCH(
'City'[Name],
"Dear Field","Dear Park",
"Dear Park", "Dear Park",
'City'[Name]
)

[Anonymous]

Thanks, That helped one of my visuals. Do you happen to know why similar fields in the same table do not seem to be connectd? It seems that the CityRename and the 'City'[Name]' are not necessarily interchangeable even if they contain the same values. 

[ExcelMonke]

It is hard to say with the information given so far. If you are able, please share your current scenario, and intended scenario (screenshots, etc.)