Parameter based filter inside calculated field not working properly

Question & Answer
,
1

Hi All,
I have created a calculated field which is using parameter value as a flag like,

ifelse(
in({Filter_question_type} ,${Parameter_question_type} )
,total_question,
0)

Here I am using a List based parameter and Filter_question_type fields is present inside my dashboard. When I select all items inside my parameter, the output goes to 0 while if I select n-1 items it works file.
Note: n denotes all possible values of parameter

2

Hi @Karan_Chhabra

I reproduced the same behaviour, which I can’t explain yet, but I managed to get the desired behaviour if I hide the “Select All” option in the parameter control (Format control->Control Options).
image

Let me know if this helps and provides a solution.

Many Thanks,
Andrew