Forum Discussion

tgo's avatar
tgo
Frequent Visitor
8 years ago
Solved

Concatenate Rows in Visual

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

Need Help

3 Replies

  • tgo's avatar
    tgo
    Frequent Visitor
    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
    )
    )