How do I stop Power BI from repeating the unique ID in a table?

[jpino]

I am pulling data (which I have no control over) into Power BI via direct query. I know that this data has repeating values in several columns, but my unique ID is the project that one or more people are working on together. My table visualization has columns for ProjectID, KeyPersonnel, ProjectStatus, and ProjectTitle. I want to organize the table by ID and list all personnel in the second column. Unfortunately, my table is instead repeating the ID with a row for each person on the project.

For example:

ProjectID	KeyPersonnel	ProjectStatus	ProjectTitle
190884	Smith, John	Complete	"Random Title"
190884	Doe, Jane	Complete	"Random Title"
190892	Bush, Kate	In Progress	"Other Title"

I want it to look like this:

ProjectID	KeyPersonnel	ProjectStatus	ProjectTitle
190884	Smith, John; Doe, Jane	Complete	"Random Title"
190892	Bush, Kate	In Progress	"Other Title"

I have tried switching to a matrix, with ProjectID under rows and everything else under values, but that just forced my users to click on the + symbol to view more than the first person named and it still showed repeating rows. Any ideas? I am not very familiar with DAX yet, so if that is the solution, please tell me what I need to paste into a blank query.

[Ashish_Mathur]

Hi,

This measure works

Personnel = CONCATENATEX(VALUES(Data[KeyPersonnel]),Data[KeyPersonnel],",")

Hope this helps.

[vicky_]

You'll need to use the CONCATENATEX function to get the names to show in one line. Assuming that the Personnel are in a separate table from the project details, it would be something like
Key Personnel = CONCATENATEX(PersonnelTable, [Key Personnel], "; ")

I've noticed that you are using Direct Query mode, and there are some cases where you CONCATENATEX will not work, so please read the docs. 

[jpino · Accepted solution]

I found a simple solution by right-clicking on the column in my visual and choosing "new quick measure." Then I chose the calculation for text: concatenated list of values. This created a new "measure" under fields, which I've been able to customzie as needed. It now shows all my key personnel in one column with a semicolon between the names. It hasn't seemed to interfere with my direct query yet.