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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
juhayes
New Member

New to Power BI

Quick Question,

 

I'm currently conducting a Profit Margin calculation where our company has costs associated with no sales on the same day. Thus, our Profit turns into a negative number for that day. I'm attempting to calculate the Profit Margin for that day but am getting an "-Infinity" result, I'm guessing from a 'divide by zero' error. Here is my formula, very simple:

 

ProfitMargin = Test_Sales[Profit]/Test_Sales[Revenue]

 

I've changed the formatting to percentage in BI Modeling etc. Just not sure where to go from here.

 

 

2 ACCEPTED SOLUTIONS
chrisu
Responsive Resident
Responsive Resident

This seems like a good scenario for DIVIDE, which lets you account for divide by zero errors..  Like this:

 

ProfitMargin = DIVIDE(Test_Sales[Profit,Test_Sales[Revenue],0)

 

See: https://msdn.microsoft.com/en-us/library/jj677276.aspx

View solution in original post

v-ljerr-msft
Employee
Employee

Hi @juhayes,

 

As chrisu have mentioned above, you should use DIVIDE Function (DAX) to perform the division in this scenario.Smiley Happy

 

Regards

View solution in original post

2 REPLIES 2
v-ljerr-msft
Employee
Employee

Hi @juhayes,

 

As chrisu have mentioned above, you should use DIVIDE Function (DAX) to perform the division in this scenario.Smiley Happy

 

Regards

chrisu
Responsive Resident
Responsive Resident

This seems like a good scenario for DIVIDE, which lets you account for divide by zero errors..  Like this:

 

ProfitMargin = DIVIDE(Test_Sales[Profit,Test_Sales[Revenue],0)

 

See: https://msdn.microsoft.com/en-us/library/jj677276.aspx

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors
Top Kudoed Authors