PRODUCT DAX Function in Power BI

The PRODUCT function in DAX calculates the product (multiplication) of all numerical values in a single column. It does not iterate row by row like PRODUCTX; instead, it directly multiplies all values in a specified column.

DAX Syntax PRODUCT(Column)

Parameters

column: The column containing the numbers you want to multiply. Only numeric values are processed; blanks, logical values, and text are ignored.

PRODUCT vs. PRODUCTX

Choosing the right multiplication tool depends on your data structure:
• PRODUCT: A simple aggregator. It takes a single column and multiplies all its values. It is faster for simple column-level math.
• PRODUCTX: An iterator. It evaluates an expression for every row in a table and then multiplies the results. Use this if you need to perform math before the multiplication (e.g., PRODUCTX(Table, [Rate] + 1)).

Example: Let’s create a calculated column in the table. The following computes the product of the CustomerID column in the Query38 table.

DAX

Product Column = PRODUCT(Query38[CustomerID])

The output of the above code is shown below:

Here, the number 40320 is the multiplication of all the numbers in the CustomerID column of the Query38 table.

Key Behaviors & Warnings

Zero Handling: If a single zero (0) exists in the column, the entire result of the PRODUCT function will be zero.
Blank Handling: Blanks are skipped. If the entire column is blank, the function returns BLANK.