multi value matrix, selection criteria

[Anonymous]

I have the below table, and if a "workID" has the same "RoutingID" and same month in "start_cur" as any other "WorkID", i need to concatenate the WorkIDs to be in the same cell. 

So the finish product in a PBI table on the report dashboard looks like the below excel table.

[Anonymous]

That worked perfectly. As a bonus, do you know if its possible to make the totals as counts instead of a list workIDs?

[amitchandak · Accepted solution]

@Anonymous , Create a new measure and add that to matrix visual value

Routing ID on row and month year and Column

Concatenatex(Table,Table[Work ID], unichar(10))