topic Re: Dividing Calculated Columns Resulting in Same Value for each row in DAX Commands and Tips

Dividing Calculated Columns Resulting in Same Value for each row

mngma0102 — Wed, 20 Mar 2024 19:37:20 GMT

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.

Re: Dividing Calculated Columns Resulting in Same Value for each row

lbendlin — Thu, 21 Mar 2024 00:04:27 GMT

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

Re: Dividing Calculated Columns Resulting in Same Value for each row

mngma0102 — Thu, 21 Mar 2024 00:26:10 GMT

I am trying to create a measure

Re: Dividing Calculated Columns Resulting in Same Value for each row

lbendlin — Thu, 21 Mar 2024 00:58:40 GMT

Re: Dividing Calculated Columns Resulting in Same Value for each row

mngma0102 — Thu, 21 Mar 2024 16:49:13 GMT

Thank you it worked!