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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Justas4478
Responsive Resident
Responsive Resident

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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

October NL Carousel

Fabric Community Update - October 2024

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