Forum Discussion
Toggle Value Categories
So no you are not missing anything. Switch is pretty easy.
I wrote an article on another topic here, but the concept is the same as what you need.
https://exceleratorbi.com.au/measures-on-rows-here-is-how-i-did-it/
Hi Matt. Thanks for the answer. I figured it out and implemented. It slowed the model down considerably. Not sure why. Strange becuase just three simple measures are switched ...
Anyway, it works, so will use it.
So no you are not missing anything. Switch is pretty easy.
I wrote an article on another topic here, but the concept is the same as what you need.
https://exceleratorbi.com.au/measures-on-rows-here-is-how-i-did-it/
Hi Matt. Thanks for the answer. I figured it out and implemented. It slowed the model down considerably. Not sure why. Strange becuase just three simple measures are switched ...
Anyway, it works, so will use it.
My understanding is this is a known "problem". When you use switch, you are really just using IF, and IF evaluates each option fully even though it only uses one of them. So it should take 3 times longer with 3 options. However the fact that this is perceptible probably means that there model is inefficient in some other way.