Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Divide two measures, but gives wrong answer when I represent it as percentage

Hello all, 

 

I'm trying to divide two measures I have created in power bi, and in gives a correct answer.

But when I display the answer in percentage in gives a wrong answer.

 

This is my measure,

CO2 Ratio = DIVIDE(([1st Period CO2 from energy] - [2nd Period CO2 from energy]),[1st Period CO2 from energy])

It gives as example 15.54%, and the correct answer is 15.11%.

 

Can someone help me to fix the issue?

 

Thank you

  • Anonymous's avatar
    Anonymous
    1 year ago

    Thank you omid for your response,

     

    I found out that it takes the whole number, even wuth the decimal points that is not showing 

    So when I cheked it gives a corect pecentage.

     

    thank you again

2 Replies

  • Could you let me know the value of 1st Period CO2 from energy and 2nd Period CO2 from energy

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thank you omid for your response,

       

      I found out that it takes the whole number, even wuth the decimal points that is not showing 

      So when I cheked it gives a corect pecentage.

       

      thank you again