Forum Discussion
Calculation Groups within Measure Calculations
Hi
I need some help with selectively applying calculation groups. In my data model, I have 5 types of measures:
Measure Type 1: measures where the calculation group should not be applied
Measure Type 2: measures where the calculation group should be applied
Measure Type 3: measures where a specific calculation item should apply, regardless of the calculation item selected
Measure Type 4: measures that are a calculation combining a measure type 1 and a measure type 3
Measure Type 5: measures that are a calculation combining a measure type 2 and a measure type 3
Measure Type 6: measures that combine two measures of type 3, where each has a different calcuation item applied
Up to now, I have been able to implement all measure types by using a disjointed table containing the same names as the calculation items and using the DAX TREATAS() function to selectively apply the calcuation group. However, TREATAS() comes with a significant performance cost, so I want to move away from TREATAS().
I have considered using a filter for SELECTEDMEASURENAME() but I suspect this would not work for measure types 3-6.
I'd appreciate any pointers as to what approach I can use to gain performance benefits but keep functionality.
5 Replies
- bcdobbsCommunity Champion
Have you got a demo file?
Short of a direct relationship TREATAS is generally the best way to move a filter so would like to see what you're already doing in a bit more detail. - bcdobbsCommunity Champion
Have you seen this article that was in SQLBI's january newsletter:
A Technique for Optimising Calculation Group Performance – Tenfingers BI (wordpress.com)
I'm not sure it's 100% what you need but you might be able to use some of the ideas.- EP1Advocate IV
Thanks, I have seen it but I'll revisit it.