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

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