Turning a column into a measure

[fiveone]

Conditionnal formating, color saturation and so on require a measure, not a column, to be able to add a touch of color to my visualization.

So I need to turn text column into measures. What is the best way to do that?

I tried the following but don't really like it

columnToMeasure =
SWITCH (
MAX([Column]);"A";1;
MAX([Column]);"B";2;
MAX([Column]);"C";3;
0
)

[Vvelarde]

@fiveone

columnToMeasure =
SWITCH (
VALUES(Table1[Column]);"A";1;"B";2;"C";3;0)

[fiveone]

Thank you for clarifying the right use of the switch function 😉

Unfortunately I still end up with the following error

It does work with MAX though, but I am not a big fan of this trick ;-(

Profile ID = 
SWITCH (		
MAX('Unique Won SR Details'[PROFILE OF CANDIDATE]);"JR";1;"INT";2;"SR";3;0
)

[Vvelarde · Accepted solution]

@fiveone

The error message is because in a total Row is using all the rows in the filter context.

So to avoid this message you can use IF(HASONEVALUE('Unique Won....'[PROFILE OF CANDIDATE]), SWITCH.....

Let me know if works

[fiveone]

Nice!

You are clearly da man!

The following works like a charm

Profile ID = 
IF(HASONEVALUE('Unique Won SR Details'[PROFILE OF CANDIDATE]);SWITCH (VALUES('Unique Won SR Details'[PROFILE OF CANDIDATE]);"JR";1;"INT";2;"SR";3;0);0)

[Greg_Deckler]

I think that will successfully create a measure but not sure if that will work in the context of a visual. I think that will depend.