SQL table join changes case aggregate statement logic

Using the code below, when I use the case statement without joining tables together, I have no issue.