Concatenate Rows in Visual

[tgo]

Hi all,

I was wondering if it was possible to concatenate rows in visual. 

I have data like that:

Name+Age Name Age

Michel-33    Michel 33

George-15   George 15

Jordan-33    Jordan  33

The column Name + Age is already a concatenation of Name and Age. When I apply the filter in the visual on Age:33 I would like to obtain

Michel-33                            Michel                         33

Jordan-33                            Jordan                         33

Michel-33 / Jordan-33         Michel/Jordan        33/33

I'm struggling to obtain the last row and I'm wondering if it's possible to do so? Do you have any idea?

Thanks in advance

[tgo]

I succeed it by using the quick measure / concatenate. The problem is that Values function remove the duplicate and I have a need to keep the duplicate. Does anyone have an idea of a function that could replace the "Values" function?

List of Scientific Name Part values =
VAR __DISTINCT_VALUES_COUNT = DISTINCTCOUNT('AMP_MA'[Scientific Name Part])
VAR __MAX_VALUES_TO_SHOW = 5
RETURN
IF(
__DISTINCT_VALUES_COUNT > __MAX_VALUES_TO_SHOW;
CONCATENATE(
CONCATENATEX(
TOPN(
__MAX_VALUES_TO_SHOW;
VALUES('AMP_MA'[Scientific Name Part]);
'AMP_MA'[Scientific Name Part];
ASC
);
'AMP_MA'[Scientific Name Part];
"- ";
'AMP_MA'[Scientific Name Part];
ASC
);
", etc."
);
CONCATENATEX(
VALUES('AMP_MA'[Scientific Name Part]);
'AMP_MA'[Scientific Name Part];
"- ";
'AMP_MA'[Scientific Name Part];
ASC
)
)

[v-chuncz-msft · Accepted solution]

@tgo,

Remove VALUES function and the column name, just use the table name.

[tgo]

@v-chuncz-msft

As simple as that. 

Thanks a lot