cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MP_123
Microsoft
Microsoft

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.

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.