FILTER formula

You're going to need to describe in English words, not in your attempt at Excelese, what it is you're trying to do.  

That result of 0 and 0.5 is entirely logical if you're just saying show me the values in column D (AKA "B", by the way--there are ambiguities throughout your spreadsheet) where you see "Z" in B1:B6 (there you do use the correct column labels.

In fact, if you get rid of your "A" "B" "C" "D" in row 1, replacing those with either nothing (they're not really needed, and are confusing maybe even to you; certainly to an outside observer) or with some other heading that represents what they are, Mon, Tue, Wed, Thu perhaps.... maybe the solution would be apparent to you.

The only other thing I'd suggest, and again it depends on what you're actually trying to do, is this: to give FILTER multiple criteria for the screen, you use parentheses separated by * to indicate (criterion 1)*(criterion 2)

Here's a good reference describing how to use FILTER.