Help with SUBSTITUTE() expression

Hi

I am using the following expression to get the [Pole Code] values in the screenshot attached and it works perfectly fine.
SUBSTITUTE(SELECT(Works_Orders_Master[Creosoted Code],[Charge Number] = [_THISROW].[Charge Number]) , " , " , "
")

However when I use the following expression to pull out the corresponding [Quantity] values I am only getting the quantity of the first value.
SUBSTITUTE(SELECT(Works_Orders_Master[Total Quantity],[Charge Number] = [_THISROW].[Charge Number]), " , " , "
")

Any help on this would be great, thank you.

0 3 341
3 REPLIES 3
Top Labels in this Space