Hi Shawn Wallwork,
What do you suggest? I don't think there is a way to have the user multi-select a parameter to decide who goes onto the numerator and denominator. One really stupid way I can think of is, creating multiple parameters for each field in the calculated field, and have the parameter value be true/false. For example:
%Occupancy: [Parameter 1] + [Parameter 2] + ,,, / [Parameter 1] + [Parameter 2] + ....
CASE [parameter1] when TRUE then sum(Duration) ELSE 0
Hope this makes sense, and hope there is an easier way.
How about you flip it around? Set up a parameter with the different combinations of numerator/denominator, then set up a measure driven by CASE statement that returns the right values.
CASE [your parameter]
WHEN "talking per state" THEN ...equation...
WHEN "talking + email" THEN ...equation...
An advantage to this is that you have a single parameter that you can then use in building worksheet titles, tooltips, etc.