Find my approach based on UNION as reference below and stored in attached workbook version 10.4 located in the original thread,
1. Define UNION
2. D1. All/Local: if [Table Name]="Sheet1" and ([dimension]="A" or [dimension]="B") then "All"
elseif [Table Name]="Sheet1$" and [dimension]="A" then "Local" end
3. Drag the required objects to the indicated location and exclude Null from the object D1. All/Local
UNION All-Local_nalmai_10.4.twbx 13.3 KB
Norbert Maijoor thank you but my dataset is already huge and union will make it even more complicated.
Josh Kushner, I tried your approach but it looks like I will need to include that parameter into every calculated field I used, which there are tens of them. Is there any other way to apply this parameter as a filter?
Exchange your filter for a parameter
then a calculated field
if [dimension] = 'A' then [measure] end
Then in your parameter calculated field
when 'Local' then [the above calculated field]
when 'All' then 1=1
the 1=1 code is just a do nothing bit of code, but the result will be it displays both fields.
Thank you. The helper calculated field you put there has [measure] therefore this filter will apply to only that [measure]. However, I have tens of measures that will be effected by this filter I am trying to create so if possible I need more general solution.