Filter across sheets and Pick Function for Choosing a Measure Query

[ss09]

Would you have some time to help me understand 2 issues.

1. So in one sheet I would like my filter on a field to be multi-select and in another sheet I would like it to be single select filter, how can I go about doing that?
2. Also can I not use Pick(vLanguage, col_english, col_french) in a filter (2 columns have translations) <- this doesn't work but some how Pick(vLanguage, 'col_name_english', 'col_name_french') seems to work.

[Gabbar]

For 2nd, It is not working because in Pick(vLanguage, col_english, col_french)  col_english,col_french are dimension or variable but when you put them in incerted commas they become values.

Now for 1st no it is not possible to make a field be single selectable on one sheet and multi on another,
but there can be a different solution like:- Let the Field name be D1
In the sheet you want filter to be multi-selectable , let it remain that way as default filter pane are multi-selectable.
Now for second sheet create a variable name vD1 and assign it any random Value from D1 in its definition this will be its default value, after that add variable input and select vD1 , and in its values select Dynamic.
For Dynamic Set the set Expression to be  Concat(distinct D1,'|') .
Now in your set expression for this sheet add D1 = {"=$(=vD1)"} , for required expressions.

[ss09]

So what would be the best way to figure out so that in Pick(vLanguage, col_english, col_french)  col_english,col_french are remain as a field?

As one column has English translation and the other has French one. Based on Variable Input Filter, I need to choose the appropriate column as the filter column.

[Gabbar · Accepted solution]

For that you need to use Pick and Match Functions Together.