DAX function

CONCATENATEX — DAX function reference

Join an expression across rows.

Syntax

dax

CONCATENATEX(<table>, <expression>, [<delimiter>], [<orderBy_expression>], [<order>])

dax

CONCATENATEX(VALUES(Product[Name]), Product[Name], ", ")

→ "A, B, C"

The 4th/5th arguments control sort order independently of the table's natural order, which CONCATENATEX otherwise doesn't guarantee.

dax

CONCATENATEX(VALUES(Product[Name]), Product[Name], ", ", Product[Name], ASC)

→ An alphabetically sorted product list

dax

"Selected: " & CONCATENATEX(FILTER(VALUES(Sales[Channel]), NOT(ISBLANK(Sales[Channel]))), Sales[Channel], " / ")

→ A slicer-summary string for a report title

Without an explicit orderBy argument, row order isn't guaranteed to be stable across refreshes — always add one if the output order matters (e.g., a tooltip or exported list).
Like other iterators, the expression argument gets row context from the table argument, and any measure or CALCULATE inside it triggers context transition per row.

From Iterators & variables