The issue you’re running into is that you’re telling tableau “Display all the data for market one, then only show me 9/19/18”. What I think you want is to tell tableau “Get me only those things that have info for 9/19/18 then display the data”. You can do that with a context filter. Right click on the filter and say add to context. Here’s a great article on context filters
I've attached your workbook with the suggested changes.