Forum Discussion

Mants's avatar
Mants
Frequent Visitor
3 years ago
Solved

Create String based on results in table in report

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...
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    3 years ago

    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.

Mants's avatar
Mants
Frequent Visitor
3 years ago

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?