maybe try this other post I made Multi-Select OR filtering behaviour
I think ultimately it ended up being that I had to write the conditions in reverse.
I ended up not getting the full functionality that I wanted so I moved on, if I get a chance I will try and recreate this and see if I can figure it out again.