The data in Snapshot and Supporting is not able to be related as their is no 1/1 identifier between the two views. Snapshot uses calculated measure name fields based on some rules that can not be related directly to rows of data in Supporting on any sort of logic that I can find. The measure names created provide two values - 0 and 1 and the underlying view of these records, for example in the case of the 41 records on 2/18, this is really a subset of the 911 records that comprise the underlying data for that table. There are 41 value with sum of the value of 1 but there are still 871 records with a value of 0 in that data. The measure is providing a 0 or 1 value for each row rather than excluding some members.
We could take the field Submitted Prev Week and place this on the Filters shelf but then this will impact the values for the other Measure names.
I think you are on the right track with fixing the underlying data instead. You might consider reviewing Maestro - Project Maestro | Tableau Software which is currently in Beta to work with the data before bringing it into Tableau. Maestro is an open Beta currently.
I hope that helps.
Thanks Patrick. A lot clearer now.
Thanks for the detailed explanation. I will then go to my data and see if I can present it differently before going to Tableau.
Thanks so much again.