Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Divide not working

Dear Community !

 

Not sure why simple Divide function is not a working. Here's the table in Power BI & expected values in excel:

 

Many thanks in advance !

 

 

  • Anonymous , Hope this is a measure. Divide should a measure like

     

    Divide([Measure1],[Measure2] )

     

    Or

     

    Divide(Sum(Table[Value]), Sum(Table[Value2]) )

2 Replies

  • Anonymous , Hope this is a measure. Divide should a measure like

     

    Divide([Measure1],[Measure2] )

     

    Or

     

    Divide(Sum(Table[Value]), Sum(Table[Value2]) )

    • Anonymous's avatar
      Anonymous
      Not applicable

      Understood ! Did the trick when I used New Measure. Also realised some of the rows had zeros. Used this:

      SUM(Table Name[Value_1])/SUM(Table Name[Value_2])