Multiple tags in column for single row (news article)

[rmarian]

I have 3 tables importing from SQL database:

- unique list of news articles (columns: ItemID, URL, Title, ...)

- unique list of available tags, that editors used with the news articles (columns: TagID, TagName)

- bridge between news articles and tags (columns: ItemID, TagID), each item can have multiple tags (multiple rows with the same ItemID)

How can I visualize a table that would list the news articles and for each row show all the assigned tags, e.g. comma separated in a single column? Now I get as many rows for each article as the number of tags assigned to it.

[v-zhenbw-msft · Accepted solution]

Hi @rmarian ,

We can use the following steps to meet your requirement.

1. Change the relationship direction between bridge table and tags table to Both.  

   

2. Then create a measure, and get the result like this,

Measure = CONCATENATEX(VALUES(tags[TagName]),tags[TagName],", ")

If it doesn’t meet your requirement, could you please show the exact expected result based on the table that we have shared?

BTW, pbix as attached.

Best regards,

Community Support Team _ zhenbw

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

[rmarian]

This works like a charm! Exactly what I needed - thank you!