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.
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |