How can i write a If statement (by column name) in the measurement?

[Ericwhv]

Hi All

Thank you for clicking in this topic first

i am trying to write "Measurment" which contain IF statement
what i am trying to get is
Measurement =  Switch ( True(), Table[Column Name] = "ABCDE"(Text), [measurement] / 5333, [measurement] / 10666) 

but, seems like we cannot choose column in the measurment, do you know what is our alternative?

Thank you!

[LQuedas · Accepted solution]

Hey @Ericwhv ,

it seems you are mixing context concepts,why don't you use  a Calculated column and affecting the value with the row context, and after that calculate the measure based on that new calculated column?

hope this helps, LQ