Forum Discussion

EP1's avatar
EP1
Advocate IV
4 years ago

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 Mea...
Need Help
bcdobbs's avatar
bcdobbs
Community Champion
4 years ago

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.

  • EP1's avatar
    EP1
    Advocate IV
    4 years ago

    bcdobbs sorry, don't have a demo file. The model itself (even without the data) is confidential. I considered using a direct relationship but it doesn't look like it is possible to create a relationship on a calculation group.

  • EP1's avatar
    EP1
    Advocate IV
    4 years ago

    bcdobbs the only complaint I have with the TREATAS approach is the performance cost. In another model where I only have type 1 and type 2 measures, I successfully switched from TREATAS to a SELECTEDMEASURENAME approach with tenfold performance gains