Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Dynamic text returning multiple text values

I have a table with a company name and budget. When i click on the company name i want to have a card with dynamic text that will change to show the names of the markets they are in. How do i make a measure like that that shows all the markets. I tried some things but i only get one market back and not all of them.

 

 

Thanks

Need Help
  • MFelix's avatar
    MFelix
    6 years ago

    Hi Anonymous ,

     

    As you can see below using the measure:

     
    Market concat = CONCATENATEX('Table';'Table'[Market];",")
    I achieve the expected result, are you making a measure or a column? Does your table have the Market more than one time per company?
     
    If you have more than one value per company try the measure
     
    Market concat = CONCATENATEX(DISTINCT('Table'[Market]);'Table'[Market];",")

4 Replies

  • MFelix's avatar
    MFelix
    Super User
    6 years ago

    Hi Anonymous ,

     

    You should use the CONCATANEX formula to calculate this should be something similar to:

     

    CONCATENATEX(Table, Table[Column], “,”)

     

    Check the documentation for further explanation.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi MFelix i am not sure this is what i am looking for. The markets are all in the same column. My data looks like that.

       

       

      Company A             France

       

      Company A             Germany

       

      Company A             Japan

       

       

      So company A is in 3 markets. If i use CONCATENATEX all i get is France multiple times for some reason.

      • MFelix's avatar
        MFelix
        Super User
        6 years ago

        Hi Anonymous ,

         

        As you can see below using the measure:

         
        Market concat = CONCATENATEX('Table';'Table'[Market];",")
        I achieve the expected result, are you making a measure or a column? Does your table have the Market more than one time per company?
         
        If you have more than one value per company try the measure
         
        Market concat = CONCATENATEX(DISTINCT('Table'[Market]);'Table'[Market];",")