Forum Discussion
Concatenate Rows in Visual
- 8 years ago
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-msft8 years agoCommunity Support
- tgo8 years agoFrequent Visitor