Pivot Table Measure (Text) without Aggregation?

Creating a Pivot Table where my main row contains duplicates (sales orders, may appear multiple times depending on how many items on order)

I created a measure to show other columns text instead of counts/sums and it works fine, however it aggregates them and shows each text with commas)

Is there a way to create a measure where it only lists the first recorded value? In my instance this particular text string is always the same so I don't need it listed out like (item, item, item, item) but only (item)

Here's what I am using for my current measure

Please Login or Register  to view this content.

Are you saying instead of using

Please Login or Register  to view this content.

Just use

Please Login or Register  to view this content.

Tried this but giving me some kind of error about expecting single value but getting multiple values.

Oh lol I am dumb..this stuff is new to me, appreciate it will try that out.

That one throws errors - but it had an extra )

However this gave me the same result where it lists all values with a comma (even though they are the same).

That works, thank you

Another question, is there anything that would make these CONCATENATEX not work? I have a huge data set and I made a Measure but it will not populate. If I reduce my rows then it does. Is there a limit to rows or something else that could cause it to not work?