Aligning values in table

This is interesting, need someone smarter than I am.

I have a table that I am using a measure to format, rounding to the millions. I would like to orient the numbers to the right, so I am using the VALUE function. However, it will work for one column and not the other. Both are formating a different measure that is a CALCULATE(SUM(column)). Both are identical, but one will orient using VALUE and one will not.

AFM DIR is using the VALUE function, the Obs will not.

The one that I want to use the VALUE function with.

The one that works.

I cannot figure out why it works with one and not the other, thoughts?

=NoMy