Switch True

[gauravnarchal]

I need help with the Switch True Measure.

If supplier is 123456 then return "preferred" else "non preferred".

Table 1

Supplier
123456
12322
13123
2313123
123122
2312
13123123

[PaulDBrown · Accepted solution]

Assuming the supplier column is type text,
As a calculated column:

status = IF(Table[Supplier]= "123456", "Preferred", "Non Preferred")

As a measure:

status = IF(MAX(Table[Supplier]) = "123456", "Preferred", "Non Preferred")