Forum Discussion

EP1's avatar
EP1
Icon for Advocate IV rankAdvocate IV
4 years ago
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...
Need Help
  • EP1's avatar
    EP1
    4 years ago

    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.

EP1's avatar
EP1
Icon for Advocate IV rankAdvocate IV
4 years ago

parry2k , thanks! I'll do the checks and revert with my findings

EP1's avatar
EP1
Icon for Advocate IV rankAdvocate IV
4 years ago

parry2k , all the measures are interlinked but below are the metrics for a matrix with the SWITCH logic and with calculation groups - that was the only change I made (besides for changing cross filter relationships from both to single).

 

SWITCH Formula

 

Calculation Group

 

The fact table of this model has about 8M rows and 27 columns. There are about 8 master data tables conected in (practically) a simple star schema. The model itself isn't very large - only about 180MB - and the measures are moderately complex.

 

Unfortunately, I cannot post much more information, so I guess I'll have to figure this one out on my own or revert to SWITCH logic.