What it boils down to is such:
IF(Condition)
WHERE Column_Name = 'x'
ELSE
I don't want a 'WHERE'
I had this for a while, but it's not working the way I want due to the fact that there is no else statement:
WHERE Column_Name = CASE
WHEN(Condition != 'All') Then 'x' end