PRODUCTX Function (DAX)
How does the PRODUCTX function (DAX) work?
The PRODUCTX function (DAX) returns the product of the numbers resulted from an expression evaluated for each row in a table.
PRODUCTX Formula Syntax
PRODUCTX(
<table>, <expression>
)
How do you use the PRODUCTX function?
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.
Related Blog Posts
Related Support Forum Posts
Best Practice for Data Model: 1 transaction, multiple items
Calculations based on different data granularity
Filtering sales table based on specific basket item
Considerations when using the PRODUCTX function
Only the numbers in the column are considered. Blanks, logical values, and text are ignored.
Related Video Tutorials
Formula examples using the PRODUCTX function
=[PresentValue] * PRODUCTX (AnnuityPeriods, 1 + [FixedInterestRate])