Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Justas4478
Post Prodigy
Post Prodigy

How to change divide -1 result to show as blank

Hi, I have this measure.

Demand last 2 week % difference = DIVIDE('Outbound Delivery'[Demand last 2 week difference],'Outbound Delivery'[Demand last 2 week],0)
It return these results that all are correct.
Justas4478_0-1722938504594.png

Thats how they look before showing as a %

Justas4478_1-1722938541048.png

What I am trying to change is when a results is -1(-100%) to show blank instead.
This is expected result:

Justas4478_2-1722938851359.png

Do I just need to introduce if statment in the dax?

Thanks

1 ACCEPTED SOLUTION
bhanu_gautam
Super User
Super User

@Justas4478 , Try updaing measure as 

 

Demand last 2 week % difference =
VAR Result = DIVIDE('Outbound Delivery'[Demand last 2 week difference], 'Outbound Delivery'[Demand last 2 week], 0)
RETURN IF(Result = -1, BLANK(), Result)



Did I answer your question? Mark my post as a solution! And Kudos are appreciated

Proud to be a Super User!




LinkedIn






View solution in original post

2 REPLIES 2
bhanu_gautam
Super User
Super User

@Justas4478 , Try updaing measure as 

 

Demand last 2 week % difference =
VAR Result = DIVIDE('Outbound Delivery'[Demand last 2 week difference], 'Outbound Delivery'[Demand last 2 week], 0)
RETURN IF(Result = -1, BLANK(), Result)



Did I answer your question? Mark my post as a solution! And Kudos are appreciated

Proud to be a Super User!




LinkedIn






@bhanu_gautam It looks like to be working without any problems as the moment.

Justas4478_0-1722939492637.png

Thanks for the help.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors