Good evening @Super_Kay and welcome to the ODK Community forum.
When you get a chance please take some time to introduce yourself here
The choice_filter has to be applied on a column from the choices or entities list : https://docs.getodk.org/form-logic/#filtering-options-in-select-questions
In your case it should look like :
household_id = ${household_id}