Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 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 resu...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 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
6 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
    6 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi amitchandak 

       

      here is a data sample: sample.pbix  

       

      Thanks for the help!