Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Issue with using a calculated column in a selection list

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])

Need Help
  • ExcelMonke's avatar
    ExcelMonke
    2 years ago

    Consider changing the calculation to:

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

3 Replies

  • ExcelMonke's avatar
    ExcelMonke
    Impactful Individual
    2 years ago

    Consider changing the calculation to:

    CityRename = 
SWITCH(
'City'[Name],
"Dear Field","Dear Park",
"Dear Park", "Dear Park",
'City'[Name]
)
    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      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's avatar
        ExcelMonke
        Impactful Individual
        2 years ago

        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.)