How to get if else for a text field in Measure

[Anonymous]

HI I have a table with column as Color as below:

Color

Red
Green
Yellow
Pink

What I need is to create a measure like this:

Color    Measure
Red       1
green    2
Yellow   3
Pink       4

I hope this is simple and can be easily done, I am trying if else but unable to get the result.

Thanks

[v-qiuyu-msft · Accepted solution]

Hi @Anonymous,

You can create a measure with If() function or Switch() function, see: 

Measure(IF) = IF(MAX('Table3'[Color])="Red",1,IF(MAX('Table3'[Color])="green",2,IF(MAX('Table3'[Color])="Yellow",3,IF(MAX('Table3'[Color])="Pink",4,BLANK()))))

Measure(Switch) = SWITCH(TRUE(),MAX('Table3'[Color])="Red",1,MAX('Table3'[Color])="green",2,MAX('Table3'[Color])="Yellow",3,MAX('Table3'[Color])="Pink",4,BLANK())

Best Regards,
Qiuyun Yu

[CarlosCaminero]

Hi, i´m new with P.BI, i used your formula for my problem and it worked, but i don´t understand why you use MAX with text values, ¿Could you explain it?

thanks!