Forum Discussion
Anonymous
3 years agoNot applicable
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
- amitchandak
Super User
Anonymous , Hope this is a measure. Divide should a measure like
Divide([Measure1],[Measure2] )
Or
Divide(Sum(Table[Value]), Sum(Table[Value2]) )
- AnonymousNot 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])