The issue - In Survey Data you might have 10th or even 100ds of parameters per questionnaire, Sisense suggest to transpose all the parameter into one column (See article ). Once you do that you might run into an issue filtering questionnaires that answered A AND B, in a simple filter you will actually get A OR B.
How it looks on the dashboard when you filter 1 AND 3
Step One - If dimension doesn't exist, Create two new Distinct dimension table one for the ID and the other for the indicator and connect them to the matching field
Step 2 - Create a value with an IF statement "flagging" any values that has the same amount of indicators as we selected (In our case we selected 2 Indicators)
Result - We see only the ID that has all of the selected indicators (In our case ID 1)