Returns the product of an expression evaluated for each row in a table.

To return the product of the numbers in a column, use PRODUCT function (DAX).


PRODUCTX(<table>, <expression>)  


Term Definition
table The table containing the rows for which the expression will be evaluated.
expression The expression to be evaluated for each row of the table.

Return value

A decimal number.


The PRODUCTX function takes as its first argument a table, or an expression that returns a table. The second argument is a column that contains the numbers for which you want to compute the product, or an expression that evaluates to a column.

Only the numbers in the column are counted. Blanks, logical values, and text are ignored.


The following computes the future value of an investment:

= [PresentValue] * PRODUCTX( AnnuityPeriods, 1+[FixedInterestRate] )  

See also

PRODUCT function (DAX)