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'v...
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]
)
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.)