Forum Discussion
Solved
Scaled Value Categorization Measure
Hello, I want to preface by saying that you for your help. I currently have a working measure that calculates a “scaled value” based on a total number. That scale ranges from 1 to 0. Objec...
neil37 ,
I would like to suggest using the SWITCH function:
Category = SWITCH( TRUE(), [Scaled Value] >= .5, "Cat 1", [Scaled Value] >= .37, "Cat 2", [Scaled Value] >= .24, "Cat 3", "None" )I believe by ensuring the values are in descending order, this should work. My syntax might be a little off, but I think you should be able to get it going.
Good Luck and Regards,
neil37 ,
I would like to suggest using the SWITCH function:
Category = SWITCH(
TRUE(),
[Scaled Value] >= .5, "Cat 1",
[Scaled Value] >= .37, "Cat 2",
[Scaled Value] >= .24, "Cat 3",
"None" )I believe by ensuring the values are in descending order, this should work. My syntax might be a little off, but I think you should be able to get it going.
Good Luck and Regards,
Worked perfectly. Thank you!!!
