Create String based on results in table in report

[Mants]

Dear, 

I have a report with multiple slicers and a results table. The results in the table are determined by the slicers. 

I would like to create a string to be presented in the report, composed of the ProjectCode values that would change based on the status of the slicers. 

For instance if after applying slicers the table shows:

ProjectCode

PROJECT-1

PROJECT-2

PROJECT-3

The string to appear in a separate visual in the report will be

"PROJECT-1,PROJECT-2,PROCET-3"

Is such a function possible and how could i best do that?

[Mants]

Thank you so much! this was the solution i was looking for. so if i understand correctly, adding "VALUES" filters the table column based on the active slicers in the report?

[Ritaf1983 · Accepted solution]

Hi @Mants 
You can use concantenatex formula to achieve it.
Create a measure with code :

test = CONCATENATEX(VALUES('Table'[ProjectCode]),[ProjectCode],",")

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.