Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Simple Division Issue - Not so simple

Hello everyone,

 

I'm facing an issue of simple divison for my graphs.

Below on the left you see both values in their own graphs, on the right you see the divison.

 

Now as you can see the division isn't correct. Take december: 78/166*100%= 46.99%, it displays: 53%.

 

Code used:

DIVIDE([Value01],[Value02])

 

Hope someone can help out.

Need Help
Tips and Tricks
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    HI, Anonymous 

    If what you had created is a new column, you should create a new measure

    Try this formula:

    Measure = DIVIDE(SUM('Table'[Value1]),SUM('Table'[Value2]))

    If not your case, please share your sample pbix file.

     

    Best Regards,

    Lin

7 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi,

     

    Try DIVIDE ( [Value01] , [Value02] , 0 )

     

    Regards,

    Pavan Vanguri.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hey,

       

      it changed the value for Jan for example, but still not correct:

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hi,

         

        Can you please let me know what is Value01 and Value02.

        I mean the DAX expression.