Okay. So Switch is reading the value of the dynamic variable and building a filter based on its value. The All is for when the value equals All. The _ is a pattern that will match any other value.

When you change to CheckboxBar the dynamic variable will be a list of all the checked boxes.

In the CheckboxBar case you need to use MemberQ on the list and the Dataset column (represented by the #"..." Slot in the filter.

If you are dropping All from the selection list then you do not need the Switch. You can just build the filter with MemberQ.

Thank you for the clarification. I will revise your Code in line with your suggestion and let you know the result.

here are what changed:

none of them is working. Edmund, instead of me trying things without know what I am doing, would it be better that you just write me the code one for each place to change. That is all I need otherwise it is very difficult to do something you know but I do not.

Also, read my previous comment on dropping All.

Thank you for your very useful code and advice. Having said that, I am having a hard time understanding your refusal of giving a line of Code. As you can see, my knowledge of programming MMA is limited; that is why we are chatting. Anyway, I appreciate your great help.

Actually try to help you understand as it is pretty obvious from your snippets that your understanding is very limited. Give a man a fish vs Teach a man to fish.

I have given you a complete manipulate so I would not say I am reluctant to give code.

Dear Edmund, I really really appreciate your help. No question about it. Please understand that I try my best to understand your advice about the revisions. The thing is that I understand individual commands in MMA, but when it comes to using them in a complicated code, I cannot follow the reasoning of the revision. That is why I am not able to get what I aim to from your code. I am not complaining about your code. It does a perfect job. Again I apprecite your kind help. Thank you very much.

I would like to learn how to fish, but I recognize my capacity limitation.

MemberQ[#"status"] == status this is not going to work because you are not using the correct syntax for MemberQ. status is the list of values. #"status" is the row value you are testing is a member of the list.

I revised "Switch[status, All, True &, _, #"status" == MemberQ[status] &]", I also revised the dynamic as

country popup menu gives me trouble now