Multivitamins are a waste because they are generally low quality. Vitamin d and magnesium are both very common deficiencies and like the OP demonstrated, they give people a false sense of security.

Unless we are talking about some high quality stuff like athletic greens.