Dividing 2 columns

[Euro0681]

I am trying to simply divide 2 columns but when doing so i get a wrong value (Example Below)

The correct value I'm looking for is "1.xxxx" , Note Column1 is displaying the sum and same concept for Column2 (they are displaying the sum for the entire column)


 

[Euro0681]

@tamerj1 We can think of Column1 = quantity and column2 = price or something like that so each category has different quantity and price but the division for each is what i want to be static

[tamerj1]

@Euro0681 

Please try

=
SUMX ( 'Table', DIVIDE ( 'Table'[Column1], 'Table'[Column2] ) )

[tamerj1 · Accepted solution]

Hi @Euro0681 

create a Measure 

DIVIDE ( SUM ( 'Table'[Column1] ), SUM ( 'Table'[Column2] ) )

[Euro0681]

@tamerj1 what if i need the value to be static and not change whenever extra fields are added, in other words is there a way to do this using a column as opposed to a measure?

[tamerj1]

@Euro0681 

CALCULATE ( DIVIDE ( SUM ( 'Table'[Column1] ), SUM ( 'Table'[Column2] ) ), ALL ( 'Table' ) )

[Euro0681]

for more clarification I want the value to be static for every category. Example
Catogry1 Total = Column1/Column2 = 2.02 (made up numbers)
Category2 Total = Column1/Column2 = 1.02 (made up numbers)
 anytime i use Category1 with any other fields it should always remain '2.02' kind of like a group by in SQL?