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 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?

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.

2 Replies

  • Ritaf1983's avatar
    Ritaf1983
    Icon for Super User rankSuper User
    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?