It's hard to know what the issue is without seeing the workbook. Are you able to post it (as a twbx file)?
One troubleshooting idea would be to use the index function as opposed to the condition filter. Create a calculated field similar to the following:
Then, place this on the filter shelf.
Hope this helps!
Unfortunately the info is quite sensitive
I will try the index function Tracy, will let you know if this works