calculate divide to each row

[MP_123]

hi,

i want to divide two measures, and then to sum all the rows division.

currently, what power bi does is divide (sum(measure1),sum(measure2))

what i want is sum(divide(measure1,measure2))

and that is not the same result.

how can i do it?

thanks!!!

[BhaveshPatel · Accepted solution]

Hi There,

You can use SUMX for this purpose. 

YourSolution:=SUMX(Table,[Measure1]/[Measure 2])

If you want to achieve this using calculated column, you would not require SUMX.

Thanks & Regards,

Bhavesh