Why cant i use some columns in a measure?

[Lorentzt]

Hello.

I am having a table with the columns

ticket_id, Title, priority,

I am trying to create a measure to convert the priority number to a text name:

"SLA Priority = SWITCH([priority],1,"Minor", 2, "Average", 3, "Major", 4, "Blocker", "Missing")"

But when i try to chose [priority] in my expression only other measures are listed non of the columns is available to be chosen. I have encountered this problem several times in diferent tables i have and with diferent functions.

What am i missing? Why cant i use the column in the measure?

[Anonymous · Accepted solution]

You appear to be referencing a "naked column" where the SWITCH() function is expecting a measure.  That's why only measures appear in the IntelliSense.

use MIN(Table[Priority]) instead, that should fix it.

[v-huizhn-msft · Accepted solution]

Hi @Lorentzt,

What @Anonymous said is right, please use the following formula, it will work.

SLA Priority =
SWITCH (
    FIRSTNONBLANK ( [priority], [priority] ),
    1, "Minor",
    2, "Average",
    3, "Major",
    4, "Blocker",
    "Missing"
)

Best Regards,
Angelia

[Anonymous · Accepted solution]

You appear to be referencing a "naked column" where the SWITCH() function is expecting a measure.  That's why only measures appear in the IntelliSense.

use MIN(Table[Priority]) instead, that should fix it.