Every property has a field type, and the type decides what you can store and how filters treat it.
A dropdown select stores one of a fixed list of options. Each option has a label people see ("Connected") and an internal value the system stores (CONNECTED); imports and the API use the internal value or the exact label. A number holds digits only: "18 staff" is not a number. A single checkbox holds Yes or No. A date picker holds a calendar date.
Any of them can also be empty. Empty is not zero and not No. A contact with no lead score has not been scored; a contact with a score of 0 has. A contact whose Attended webinar is No told you so; one with no value never answered.
Filters care. In HubSpot, a number filter is equal to 0 also matches empty values, and is not equal to skips empty values unless you tick Include records with empty values. Add is known when you mean "has a value".