How to write this in dax

[Anonymous]

SUM(profit*sales) / NULLIF(SUM("sales"),0)

[Anonymous]

Hi @Anonymous,

Did Whitewater100 's suggestions help with your scenario? if that is the case, you can consider Kudo or accept his suggestions to help others who faced similar requirements.

If that also doesn't help, please share more detailed information to help us clarify your scenario to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[Whitewater100 · Accepted solution]

Hi:

If you have measures for sales and profit like: (these are just examples)

Sales = SUMX(SalesTable, SalesTable[Qty] * SalesTable [price]))

Profit = [Sales] - [COGS]

Then the measure is:

Result = DIVIDE([Profit] * [Sales], [Sales],0)

I hope this helps - basically the DIVIDE function handles divide by zero issues...