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

Related DAX Functions

Related Course Modules

DOWNLOAD

To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.