I assume you have the data like below and you want to exclude the incomplete rows.. (from the below eg: keep only Albuquerque and exclude rest). If your requirement is same then you can achieve this by using a table calculation filter.
I have used the Tableau Super store sample data and created the following calculation named "Row filter"
Then place it on the filter and check "True"
You will have only complete records rows in the output. Please let us know if your requirement is different
Row Filter.twbx 448.9 KB
Thanks...a little variation of this will work for me.