Using a measure on a string based column

[OsmanEmi]

Hi,

I have a data set like the one below.

I'm trying to write a measure so that the measure outputs a corresponding text when it compares the values in the column.

I know it would be easier doing a calculated column however I can't modify dataset unfortunately.

for example

if the column displays "1" i would like to output London or if it displays "2" Paris and so on.

Please note although the column is a integer the data type is string

Location

1

2

3

4

5

[lbendlin · Accepted solution]

Measure := switch(SELECTEDVALUE('Table'[Column]),"1","London","2","Paris","Elsewere")