PRODUCTX

PRODUCTX is a DAX function that returns the product of an expression evaluated for each row in a table.

Syntax

PRODUCTX(
   Table,
   Expression
)

Argument	Properties	Description
Table		Table over which the Expression will be evaluated.
Expression		Expression to evaluate for each row of the table.

Return Values

A decimal number.

Remarks

• To return the product of the numbers in a column, use PRODUCT.

• 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.

• This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.

The following computes the future value of an investment:

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

Related functions

Other functions related to PRODUCTX are:

• PRODUCT

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/dax/productx-function-dax