Today a quick tip about how use the case MicroStrategy function multiple times. To do that you just have to:
- Create a metric
- Add an expression like this:
Case(([metric] = 1),‘true’, ([metric] = 2), ‘true’, ‘false’)
Blue: The condition
Green: When the condition is true
False: When the condition is false
This way, you can add as many conditions as you need. Just replace the ‘false’ part with a new condition.
Hope it helps.
God bless you