DAX needs a special division-by-zero operator - by Marco Russo

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 622995 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 11/18/2010 9:59:37 AM
Access Restriction Public


So much time and space is spent in DAX handling division by zero, why not have a special operator for it or handle it automatically? At the moment we always have to use something like IF(d=0, null, n/d) which takes a lot of unnecessary space, and is something people new to DAX often fail to do.
Sign in to post a comment.
Posted by PaoloLec on 5/30/2013 at 2:27 AM
Use only DIVIDE is essential for good performance on analysis. With the use of IF the time to resolve calculated measures is about 30x slow more than DIVIDE!
Posted by rimonh on 2/28/2012 at 11:53 PM
I would suggest something like Excel IsError. So it will be: IsError(n/d , null) . A function like that will handel more cases.
Posted by Lisa [MSFT] on 11/18/2010 at 1:33 PM
Hi Darren,

Thank you for submitting this connect item. We will look into it and get back to you as soon as we have some update for you.

Thanks again!

Lisa Liu
Sr. Escalation Engineer
Microsoft SQL Server Analysis Services Support
Posted by Darren Gosbell on 11/18/2010 at 11:31 AM
We need either a special divide by zero operator that returns a blank if the denominator is 0 or Blank. Or the existing divide operator could be enhanced to do this by default.