Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
Calculated column
Calculated table
Measure
Visual calculation
Returns the product of an expression evaluated for each row in a table.
Syntax
PRODUCTX(<table>, <expression>)
Parameters
| 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.
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.
Example
The following computes the future value of an investment:
= [PresentValue] * PRODUCTX( AnnuityPeriods, 1+[FixedInterestRate] )