Dividing items within the same column

[dw700d]

Good day all, I am pretty sure this is simple but I just cant figure it out. I  would like to create a measure that divides the sum of Version 1 by the sum of Version 2. How can I accomplish this?

Source	Amount
Version 1	100
Version 1	150
Version 1	200
Version 1	250
version 2	320
version 2	290
version 2	500
version 2	610

[manikumar34 · Accepted solution]

@dw700d ,

Try the below.

DIVIDE(CALCULATE(sum(Table[Amount]),Table[Source] ="Version 1"),CALCULATE(sum(Table[Amount]), fTable[Source] ="Version 2"),0 )

Try not to use FILTER function which cuases the perfomrance issues.

Regards, 

Manikumar

[amitchandak]

@dw700d , Please try a new measure

divide(calculate(sum(Table[Amount]), filter(Table, Table[Source] ="Version 1")),calculate(sum(Table[Amount]), filter(Table, Table[Source] ="Version 2")) )