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 - Countr...
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]]] )
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

 

Ashish_Mathur's avatar
Ashish_Mathur
Super User
4 years ago

Hi,

Explain the question and show the expected result.

  • 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

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      4 years ago

      Hi,

      I still cannot understand much.  The images are way too small.