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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

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
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors