PRODUCTX
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] )