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

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

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
PBIApril_Carousel

Power BI Monthly Update - April 2025

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

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

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

Top Solution Authors