I assume you are talking about [Choose Primary Measure].

Notice how that goes onto the SIZE shelf as SUM([Choose Primary Measure] ?

That's why you can't mix aggs and non-aggs.  If you had an aggregate in the calc, then the SUM() would be aggregating an aggregate.

In that calc, change all the measures to SUM([Sales]), SUM([Quantity], etc.  Then they will also be aggs, and you can add your aggregate calc.  Take the current pill off SIZE, and re insert it after your change to the calc.  You will see that now it's AGG([Choose ...]) and you'll be all set.

Hi DAve

you can create aggregate versions of all the measures

and then use this

where each measure agg is now like this

your tree will look like this

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

The canonical use for mixing values with aggregates is in generating standard scores, by subtracting the estimate of the mean, and then dividing by the estimate of the standard deviation. Universally, any mixing of aggregates with non-aggregates is accomplished by wrapping the aggregate in an empty INCLUDE level of detail calculation, which will automatically calculate over the dimensions selected on the worksheet. Thus given a measure [X], the standard score is given by the calculation.

[Z] := ([X] - { INCLUDE : AVG([X]) }) / { INCLUDE : STDEV([X]) }