Dividing Calculated Columns Resulting in Same Value for each row

[mngma0102]

Hello, 

I have 2 calculated columns, Open Units and Allocated Units. I am trying to calculate the Allocated % through this calculation:  DIVIDE(Allocated Units, Open Units, 0).  Instead of the correct value, am getting the same value for each row like below. I am now sure where this % is coming from. 

How can I get the calculation to work? Thank you in advance. 

[lbendlin]

Are you trying to create another calculated column, or a measure?

[mngma0102]

I am trying to create a measure 

[lbendlin · Accepted solution]

[mngma0102]

Thank you it worked!