t-sql case order by field and direction separately code example
Example: t-sql conditional order by multiple columns
SELECT * FROM dbo.Employee
ORDER BY
CASE WHEN Gender='Male' THEN EmployeeName END Desc,
CASE WHEN Gender='Female' THEN Country END ASC