Filter CONCATENATEX command that every value just appears one time

[Anonymous]

Hi people,

I have the following command:

CONCATENATEX(FILTER('BaseData','BaseData'[OrderNumber]=EARLIER('BaseData'[OrderNumber])),'BaseData'[Team]," ")

Which shows of this result in a collumn:

My Problem is, that I want every value "A", "B", "C", "D" just one time in the s_t column if it appears. 

For example in the first row: there should be just one "A" in the s_t column.

or in the row where the "UnderOrderNumber" is "4", the row in the s_t colum should be "B C D"

I'm glad for any help, thanks in advance!

[amitchandak]

@Anonymous , Not tested, But try like

CONCATENATEX(distinct(FILTER('BaseData','BaseData'[OrderNumber]=EARLIER('BaseData'[OrderNumber]))),'BaseData'[Team]," ")

[Anonymous]

Thanks @amitchandak it shows a  circular dependency.

Doesn't work unfortunatley..

I just read, that DISTINCT is a way to don't create a circular dependencys in general.. 

Do you have an idea to bypass this error?

[amitchandak]

@Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Anonymous]

Hi @amitchandak 

here is a data sample: sample.pbix  

Thanks for the help!