I have a requirement, wherein I need to show measures values or 'All' measure values through a parameter. I have written the following expression for the calculated field.
IF [Parameter 1] = "Emails Sent" THEN [Emails Sent]
ELSEIF [Parameter 1] = "Emails Delivered" THEN [Emails Delivered]
ELSEIF [Parameter 1] = "Emails Opened" THEN [Emails Opened]
ELSEIF [Parameter 1] = "Emails Clicked" THEN [Emails Clicked]
ELSEIF [Parameter 1] = "RTE Sent" THEN [Rte Sent]
ELSEIF [Parameter 1] = "RTE Delivered" THEN [Rte Delivered]
ELSEIF [Parameter 1] = "RTE Opened" THEN [Rte Opened]
ELSEIF [Parameter 1] = "RTE Delivered" THEN [Rte Clicked]
ELSEIF [Parameter 1] = "Calls" THEN [Calls]
END
And below is how I have set up the parameter ([Parameter 1])
I need to show 'All' the values when I select 'All' in the parameter else individual values whatever is selected.
I have also attached the worksheet.
Sorry ZZ, this incorrect.
I use 'All' whenever I build parameters to enable all data, exactly as Varun has requested.
The easiest way to build the 'All' function and see it in action is with a boolean calculation eg, using Superstore and regions:
pRegion = 'Central', 'East', 'South', 'West', 'All'
Now create this calculated field: [fRegion]: pRegion = Region or pRegion = 'All'
Bung fRegion to filters and set to True, therefore, when a user selects a given region, the data filters to the selected region, when they choose 'All', the data for all the regions is selected.
@Varun following this logic, we shall need to rebuild your calculation - apologies, I'm on my tablet right now so shall help rebuild your clc as soon as I can but, taking your first calculated field, we'll call it pFilter we could (this may not work, thinking aloud here) do something like:
pFilter = [Parameter 1] or [Parameter 1] = 'All'
May need to play with this one.
Steve
