Need Help in Row level formula

Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

Gunja , The information you have provided is not making the problem clear to me. Can you please explain with an example.

New Measure = divide(sum(Table[CM]), sum(Table[revenue]))

The division should always be sum(A)/Sum(B), Not Avg(A/B)

if you need the second one

averagex(Table,divide(Table[CM], Table[revenue]))

https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/
Appreciate your Kudos.

Hi Amit

Thanks for the response, my table is as below, what I need is to insert a calculated row which should give me a CM% on revenue