Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
MP_123
Microsoft Employee
Microsoft Employee

calculate divide to each row

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!!!

1 ACCEPTED SOLUTION
BhaveshPatel
Community Champion
Community Champion

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

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.

View solution in original post

1 REPLY 1
BhaveshPatel
Community Champion
Community Champion

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

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors