Forum Discussion

pbiforum123's avatar
pbiforum123
Icon for Post Patron rankPost Patron
3 years ago
Solved

Comma separated value for same rank in table

We have created the table with Rank like below.     What Client is expecting is below. Instead of showing multiple rows for the same rank they want show only one row for the companies with s...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    Thank you for your feedback, and please check the below picture and the attached pbix file whether it suits your requirement.

     

     

     

Samarth_18's avatar
Samarth_18
Icon for Community Champion rankCommunity Champion
3 years ago

Hi pbiforum123 ,

 

You can write a measure as below:-

Measure_ = 
CONCATENATEX ( VALUES ( 'Table (2)'[Company] ), [Company], "," )


Thanks,

Samarth

 

pbiforum123's avatar
pbiforum123
Icon for Post Patron rankPost Patron
3 years ago

Samarth_18 I tried this but it is not working can you please share the sample pbix file.

 

Please note that in our case Rank that you see here is a measure.