Rolling Average Responding to Only Some Filters

This has had me stumped for weeks. I am trying to create a rolling average measure that responds to some filters but not others.    Below you can see the data. For each row, if red is 0, I want to ...