This is a very good explanation of Simpson's paradox, which is the name for this thing.

It can go arbitrarily deep and the trend can flip sign for each added controlled variable.