Forum Discussion

OsmanEmi's avatar
OsmanEmi
Frequent Visitor
5 years ago
Solved

Using a measure on a string based column

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
  • Measure := switch(SELECTEDVALUE('Table'[Column]),"1","London","2","Paris","Elsewere")

    lbendlin_0-1601519672485.png

1 Reply

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

    lbendlin_0-1601519672485.png