How to use the value of a field in a filter criterion?
You could write a custom Views filter plugin to handle your use case, I have found WebOmelette's tutorials invaluable over the years, and he has a great one for D8 Views filters: https://www.webomelette.com/creating-custom-views-filter-drupal-8. This will allow you to fine tune the query to your needs and do any kind of filtering that isn't available out of the box.