Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Concatenate Measure not Custom Column

I need to Concatenate Two text strings for a Matrix to simplify the view. We have a Data Cube that does not allow the addition of Tables or Custom Columns. DAX CONCATENATE is for a custom Column.   ...
Need Help
v-lili6-msft's avatar
v-lili6-msft
Community Support
8 years ago

Hi@ Moscuba

You can try to this measure as below:

Measure 3 = CONCATENATE (
SELECTEDVALUE ( 'Table2'[PCATID]  )&"_",
SELECTEDVALUE ( 'Table2'[PCAT Name] )
)

Result:

Best Regards,

Lin

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    This is the perfect answer which I was looking for, Thanks lot for the help. Even on the microsoft own portal they mentioned the Dax function but the syntax is incorrect when we tried using text filed name which is not measures

     

    https://docs.microsoft.com/en-us/dax/concatenate-function-dax

    =CONCATENATE(Customer[LastName], CONCATENATE(", ", Customer[FirstName]))

  • ianjablonski's avatar
    ianjablonski
    New Member
    5 years ago

    This is the same measure i was looking for except i would like to extend it by making it a count.
    Said differently I would like the measure to return the count of "Measure 3", in your example, to be used in a Card .

    Can this be done ?
    Thansk You

  • shaikarshad29's avatar
    shaikarshad29
    Frequent Visitor
    4 years ago
     

    Is it possible to include the final concatenated srting in table, without making use of original string columns inside table from where the final stringw as derived?