Combine / Concat rows of data within a measure

[Dayna]

Hello,

I have a table of data, which lists instances of an issue. In the desktop, I then have a table which does a distinct count for all the issues that exist which can be sliced for a given time period.

What I'd like to do is then have a concatenated distinct value of all the issues that the value relates to.

For example:

Timescale         | No. Issues    | Issue

January 2021   | 5                   | Server Failure, PC, User Training

The above example would have been 5 rows of data in my issues table, and the issue column is what I'd like to show which would be the concatenated / combined values of the issue for those rows.

The raw data may look like:

Date            | Issue                 | Details

01/01/2021 | Server Failure   | Text1

05/01/2021 | PC                    | Text1

10/01/2021 | PC                    | Text1

15/01/2021 | PC                    | Text1

19/01/2021 | User Training   | Text1

I don't want to do this in the tables, but rather a measure so it can flex depending on what columns I use on the table.

Can you advise how I achieve this, please?

Many thanks,

Dayna

[amitchandak · Accepted solution]

@Dayna , check if concatenatex can help

concatenatex(table, [Issue], ",")

[Dayna]

Perfect, thanks! Now I just need to work out how to stop it showing in my sub totals 😉