Forum Discussion
Solved
Calculation Groups Slows Performance
I've moved my data models away from SWITCH statements to Calculation Groups but have noticed that the Calculation Groups are often slower than the SWITCH statements. To selectively apply the calculat...
For anyone with the same issue, I seem to have found the problem. It appears that the TREATAS() filter expression that I was using to selectively apply the calculation group logic is what was slowing down my measures.
When I used the calculation group directly, the calculation time was reduced to even less than when I used the SWITCH logic.
I haven't had time to read in detail yet but saw this the other day which might be of use: