DIVIDE – division handling zero (DAX – Power Pivot, Power BI)
This article is about the DIVIDE function that solves division in DAX.
Unlike classical division using "/", DIVIDE does not have a zero division problem.
For example, using DIVIDE, we could calculate the average price of one piece for each row in that table - dividing the total price by the number of pieces.
The syntax is like this. Simply enter columns that are divided:
Note that a blank cell appears in the line where it is zero - which is quite practical. If we did not use DIVIDE, infinity would appear, and any calculation with this column would be impossible.