Order Numbers with Multiple Serial Numbers

[JChouris]

Kinda new with a lot of this. I am trying to generate a report to show the serial numbers asscoiated with each order number, for order numbers with multiple serial numbers i want them to all be in one row instead of duplicating the order number throughout the column. I wasnt sure how to go about this so figured i would post. Any help is greatly appreciated. Thank you.

[ryan_mayu]

@JChouris 

what about create a measure to combine serailnum?

Measure = CONCATENATEX('Table','Table'[serialnum],",")

[JChouris]

When i use that it doesnt distinguish between the order numbers and just puts all serial numbers following each other...

[JChouris · Accepted solution]

I played with the formula a bit and found the solution. Thank you for you help.