Need Help in Row level formula

[Gunja]

I am trying to build a report, where I am struggling to get a row, where I can use a calculated row like CM% on Revenue

the formula should be CM/revenue

Please help

[Gunja]

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

[amitchandak]

@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.

[Greg_Deckler]

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.