SQL Server Where子句Case语句?

I have a Where Clause that checks the existence of rows in a subquery, but I only want to execute that check if a bit is set to 1. So for example:I have a Where Clause that checks the existence