This content has been marked as final.
Show 1 reply

1. Re: Calculation across all measures in a view?
Tracy Rodgers May 17, 2012 11:35 AM (in response to Andrew Fisher)Hi Andrew,
Would using a parameter which references each of the measures help get the desired outcome? Then, the user can switch between the desired measures. So, create a string parameter listing the desired measures.
Then, create a calculated field that references each measure. i.e.:
case [Parameter 1]
when 'Sales' then sum(Sales)
when 'Discount' then avg(Discount)
when 'Profit Ratio' then [Profit Ratio]
end
Then, plug this calculation into your 'good' or 'bad' calculation and show your parameter control.
Hope this helps!
Tracy