How to show negative number as 0 in a measure

[loverlin]

I created a Measure to calculate profit %.  I would like all negative percentages to show as 0%.  Here is the DAX used to create the measure

Profit% = DIVIDE(SUM(TABLE1[Net Profit]), SUM(TABLE1[Revenue Total]),0)

Can I include an IF statement in my current DAX and if please post an example.

Thanks

[Nathaniel_C · Accepted solution]

@loverlin,

You should be able to add to your measure, or refer to it as another measure.

Profit% = IF( DIVIDE(SUM(TABLE1[Net Profit]), SUM(TABLE1[Revenue Total]),0) )<0, 0, DIVIDE(SUM(TABLE1[Net Profit]), SUM(TABLE1[Revenue Total]),0))

or

New measure = IF ([Profit%] <0, 0, [Profit%])

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

[loverlin]

Worked perfectly.  Thank you.