We've experimented with some odd solutions, but I wonder if there is an easy way to aggregate multiple measures in a report variable. Here are the details:
Assume the universe has several numeric measures called MAX_ONE, MAX_TWO, and MAX_THREE. We take advantage of these measures for all the normal reasons. However, we also need the total aggregate MAX_TOTAL of all of those MAX values. Due to the complexity of the joins in the universe we cannot simply make another MAX_TOTAL in the universe, so instead, we are trying to create this as a report variable. However, the MAX function seems to want one dimension only. I really want a MAX of the MAX values, or more genericallly, an aggregate measure that uses other aggregate measures.
I've tried to call Max() with multiple measures as parameters, but cannot seem to get the syntax correct (if it's supported at all). Wonder if there's something I'm missing to declare a set, array, or something like that... or if there is a more creative way to solve this problem.
If suggesting solutions, please remember that adding it as a new measure in the universe is not an option for us. This particular MAX is quite complex for our universe and if we try to follow that path we end up with incompatible joins or joins that produce no rows due to the nature of the schema. So we're really focused on the solution path of creating a report variable that is an aggregate of other aggregates on the reporting side at this point.