SQL Server -- More efficient alternatives to repeating an (almost) identical subquery
Hard to say for sure without seeing the full schema and queries, to work on the execution plans. But you could try:

Where
  (Select Count(Distinct fld1) From t1  ...etc... where ...etc... and fld1 In ('X', 'Y', 'Z')) = 3