cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## How to show negative number as 0 in a measure

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

1 ACCEPTED SOLUTION
Super User

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

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

2 REPLIES 2
Super User

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

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Frequent Visitor

Worked perfectly.  Thank you.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors