Forum Discussion
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 ...
I would create an entirely separate measure to cover your last scenario. Re-using measures is not good practice anyway.
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.
Thanks! Will try and do some more reading on it