topic Filter CONCATENATEX command that every value just appears one time in DAX Commands and Tips

Filter CONCATENATEX command that every value just appears one time

Anonymous — Tue, 29 Sep 2020 14:42:33 GMT

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 — Tue, 29 Sep 2020 14:55:57 GMT

Anonymous , Not tested, But try like

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

Anonymous — Tue, 29 Sep 2020 15:36:10 GMT

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 — Wed, 30 Sep 2020 01:50:52 GMT

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

Anonymous — Wed, 30 Sep 2020 14:05:37 GMT

here is a data sample: sample.pbix

Thanks for the help!