Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Mixing Iterative with Non Iterative Functions

Hey,   I have a formula which calculates, at a customer by customer level, the value of their business if new. I need to use a sumx for this to iterate down the customer table in order to check if ...
  • lbendlin's avatar
    lbendlin
    4 years ago

    I would create an entirely separate measure to cover your last scenario. Re-using measures is not good practice anyway.

lbendlin's avatar
lbendlin
Super User
4 years ago

I would create an entirely separate measure to cover your last scenario. Re-using measures is not good practice anyway.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thanks! I'm very interested in why reusing measures is not good practice. I couldn't find anything to support this on Google but would love to understand why. Is it performance related at all? My model uses a sort of cascading waterfall of measures where my first measure does a lot of the generic work, looking for selected values etc and then the next level down will be more specific to that measure. I know I will have at least 10 levels in some scenarios so just wondering if that is bad news performance wise?

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    A measure most of the time includes some sort of context transition, new context creation or context replacement. Do that in a nested fashion and you are at risk of doing a lot of unnecessary work, losing your plot, or both. Not to mention the troubleshooting nightmare when performance goes sideways.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thanks! Will try and do some more reading on it