Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Filter CONCATENATEX command that every value just appears one time

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!

4 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    Anonymous , Not tested, But try like

     

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      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's avatar
        amitchandak
        Icon for Super User rankSuper User
        5 years ago

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