You'll need to drop the "[COC]=" portion, and then it should work.
Sorry, I didn't read fully....try something like this...
IF [COC_NAME] = 'POWERTRAIN' AND [COC] = 'PT' THEN 'True'
If you want a TRUE boolean value and not just a string, do this...
([COC_NAME = 'POWERTRAIN' AND [COC] = 'PT') OR
([COC_NAME = 'EESE' AND [COC] = 'EESE')
This will return TRUE or FALSE as a boolean.
Looks like you want your parameter to mirror your dimension. In which case you can make your parameter values equal to your dimension values, which seems to be the case for all apart from Powertrain. Then create a calculated field [COC NAME] = [COC], drag it to the filters and set to True.
Depending on what you're actually trying to do you could just use the dimension as a standard filter. You can make this filter apply across multiple sheets of the same dashboard.
Thank you Andrew,
Cant believe it was a simple as that.
Slight development though.
I have an 'ALL' parameter in my parameter selections, which I would like to use to select everything when I dont have an individual one selected.
How would I make that work ?
IF [COC NAME] = 'ALL' THEN 'true'
ELSEIF [COC NAME] = [COC] THEN 'true'
Hopefully that'll do the job
Sorted this in the end using SETS and the CASE statement:
Created a SET for all items
Then a SET for each of the single selections
PARAMETER called [COC NAME] with
Calculated field in filter pane: "In" selected
Case [COC NAME]
When "ALL" Then
IF [ALL_COC] THEN "In" ELSE "Out" END
When "POWERTRAIN" Then
IF [POWERTRAIN_set] THEN "In" ELSE "Out" END
When "EESE" Then
IF [EESE_set] THEN "In" ELSE "Out" END
When "BODY" Then
IF [BODY_set] THEN "In" ELSE "Out" END
When "CHASSIS" Then
IF [CHASSIS_set] THEN "In" ELSE "Out" END
When "SVO" Then
IF [SVO_set] THEN "In" ELSE "Out" END
When "OTHER" Then
IF [OTHER_set] THEN "In" ELSE "Out" END
Thanks to everyone who helped contribute. Got there in the end.