I want to thank you both for your advice.
I have tried quite a few different setups, and unfortunately, they are all failing. It seems like it is impossible for me to use a rubric as I want for generating a grade on a simple pass/fail scale. No matter what I do, it just will not behave as I need it to. It always gives a passing score if both of the yes/no questions are yes, regardless what the other 8 items are scored.
I can't figure out why.
That is leaving me to explore switching from a simple pass/fail scale to scoring it out of 100 and setting a very high passing score. I need to see if the higher-ups will be happy with that though. If not, I will be returning to this to see if I can suss out a solution.
In the meantime, if you happen to have other ideas, please let me know.