Divide By Zero in Power BI




Nobody likes seeing errors in their reports and one of the most common causes for errors, or the use of elaborate work arounds that I see is from people not using the Divide Function in Power BI.


If you're coming from an Excel world, with experience in creating Excel based reports then you will know how frustrating it is to an error because something is dividing by zero. If you know of this problem then you most likely know how to fix it through either an 'If Error' function or maybe even conditional formatting for errors.