Forum Discussion

selimovd's avatar
selimovd
Icon for Most Valuable Professional rankMost Valuable Professional
4 years ago
Solved

Performance with many SWITCH or IFs slow. Is there a solution with good performance?

Hello everyone,   I have a kind of complex scenario and don't really know how I can solve that with appropriate performance. I have a master measure that is, depending on a slicer, calculating ...
johnt75's avatar
johnt75
Icon for Super User rankSuper User
4 years ago

You could look into calculation groups. They can be nested by using the precedence setting and should only calculate the measures that you need rather than all of them

selimovd's avatar
selimovd
Icon for Most Valuable Professional rankMost Valuable Professional
4 years ago

Thank you for the proposal johnt75.

I will give it a try.