Thank you @jrmi and @DataGecko. Selecting the id instead of the value and “Allow multiple values” or alternatively, choosing “0” instead of “All” fixed the issue.
Really appreciate the feedback from @DataGecko and the explanation from @jrmi . thanks legends!