Forum Discussion

o59393's avatar
o59393
Post Prodigy
6 years ago
Solved

Concatenate Text with Measure not Custom Column

Hi all

 

I am trying to concatenate 2 text columns with a dax measure, not with query editor's custom column.

 

I used the dax

 

 

Concat = CONCATENATE (
SELECTEDVALUE ( Query1[[L1.3 - Country]]]) & " ",
SELECTEDVALUE ( Query1[[L1.8 - Bev Segment]]] )
)

 

 

The problem is that I have to select the 2 columns in order to make work the formula. If I just drag and drop the measure "concat" by itself in a table it wont work.

 

 

Can you please help me getting the concat right?

 

Thanks

Need Help
Show and Tell
  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    Hi,

    This DAX formula works

    Measure = CONCATENATEX(Data,Data[[L1.3 - Country]]]&" "&Data[[L1.8 - Bev Segment]]],UNICHAR(10))

    Hope this helps.

  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    Or, if you just want a calculated column just do this:

     

    Column =

    CONCATENATE(Query1[[L1.3 - Country]]] & " ",Query1[[L1.8 - Bev Segment]]] )

16 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago
    Concat = CONCATENATE (
MAX( Query1[[L1.3 - Country]]]) & " ",
MAX( Query1[[L1.8 - Bev Segment]]] )
)
    • o59393's avatar
      o59393
      Post Prodigy
      6 years ago

      hi Greg_Deckler 

       

      it didnt return all the possible combinatiosn, only 1 value:

       

       

      Thanks.

      • Greg_Deckler's avatar
        Greg_Deckler
        Community Champion
        6 years ago
        Wait, what is your expected result? That was meant to create the column in your table. I don't understand what you want in your card visual. What is that?
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi

    Ashish_Mathur and Greg_Deckler 

     

    I'm using this measure:

    Measure 3 = CONCATENATEX('Dim Supplier Group','Dim Supplier Group'[COD_COUNTRY]&" "&'Dim Supplier Group'[Supplier Group],UNICHAR(10))

     

    I'm achieving this result in a matrix table

     

     

     


    Any suggestion?

     

    Thanks

    Diego

     

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hello Ashish_Mathur ,

         

        I'm looking for a solution to check the highest performing Supplier, no matter the country they are in.

        I have a matrix table where I would like to sort for more than one column

         

        The problem?
        In a matrix I can't sort more than one column, so the result that I will see is just
        the highest performer in the Country Selected.

         

        What i'm thinking?
        In a concatenation of Country Code and Supplier Group in order to get it done.

         

        This is my current configuration of my matrix table:

        Rows: Country Code(EU,PT,ES), Supplier(Zara,Coca-Cola,Amazon) Brand ( ABC,XYZ,EEE)
        Columns:         Year(2021, Month id(202101,202102)
        Values:         Measures like Conversion Rate %,Turnover etc

         

        Dummy table:

         

        I don't have the chance to create a calculated column so my only way to tackle this is by using a measure:

        What am i using:

        Measure_concate = 

        CONCATENATEX('Dim Supplier Group','Dim Supplier Group'[Supplier Group]&" - "&'Dim Supplier Group'[COD_COUNTRY],UNICHAR(10))
         
        Because i can't add the measure as a row, i added them in the vales, and this is what i am getting now:


        Output in the matrix:

         

         
        Output in a table:

         

        Any solution for this?

         

        Thank you