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, get a free DP-600 exam voucher to use by the end of 2024. Register 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
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

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.