Forum Discussion

Gunja's avatar
Gunja
New Member
6 years ago

Need Help in Row level formula

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
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

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.