I am using custom sql for Tableau and my query is dimension am using multiselect filter. The issue is values are showing DataSource level. wanted to show worksheet level filter tried context filter it is not restricting data values expected.

I found solution partially what i did is custom sql i have used where clause to restrict PM level the values are matching expected.

instead of 'DDA' i have to use multiple dropdown selection parameters in custom sql Tableau alike IN operator.

Is there any workaround for multi select parameters or with Dimension multiselect filters can we restrict worksheet level data with relevant filter values instead of showing all values from datasource ?