Extract Certain Users

[Syndicate_Admin]

Hello Experts, I have some user reports, in some cases the system assigns a chain of people for tracking, however I only need to assign a person the closure of said event to follow up, and I would not be finding a way to do it, the users I want to leave listed in a column is only one of the lab users currently highlighted in the users column.

Greetings and thank you very much.

[tamerj1 · Accepted solution]

Hi @Anonymous 
Please refer to sample file with the solution https://www.dropbox.com/t/8vsnZ9m7YnzmWJDy

Final User = 
VAR QualifiedUsers = VALUES ( 'Follow Up'[User Failure Follow Up] )
VAR CurrentUsers = Failures[User]
VAR ConvertToPath = SUBSTITUTE ( CurrentUsers, ", ", "|" )
VAR T1 = GENERATESERIES ( 1, PATHLENGTH ( ConvertToPath ), 1 )
VAR T2 = ADDCOLUMNS ( T1, "@User", PATHITEM ( ConvertToPath, [Value] ) )
VAR AllUsers = SELECTCOLUMNS ( T2, "User", [@User] )
VAR T3 = INTERSECT ( AllUsers, QualifiedUsers )
VAR NumOfQualifiedUsers = COUNTROWS ( T3 )
VAR FinalUsers = CONCATENATEX ( T3, [User], "|" )
VAR FinalUser = PATHITEM ( FinalUsers, 1 )
RETURN
    FinalUser

[Anonymous]

Admin, here you can find the edit data with the expected results.

Failure                User

1122	Luciano Martinez
1123	Camilo Sexto, Alfonzo Hernandez, Pedro Lopez, Martin Fiero, Lautaro Fernandez
1234	Martin Fiero
2432	Camilo Sexto, Lautaro Fernandez, Pedro Lopez
2488	Alfonzo Hernandez
2892	Pedro Lopez, Alfonzo Hernandez, Martin Fiero, Lautaro Fernandez, Camilo Sexto
3296	Lautaro Fernandez
3700	Alfonzo Hernandez
4104	Leonardo Castillo
4509	Juan Castro

User Failure Follow Up

Juan Castro

Luciano Martinez

Martin Fiero

Lautaro Fernandez

Leonardo Castillo

Leonardo Semprum

Alfonzo Hernandez

Carlos Ruiz

Estefania Solis

Julio Estrada

Failure             User

	Final Data Example
1122	Luciano Martinez
1123	Alfonzo Hernandez
1234	Martin Fiero
2432	Lautaro Fernandez
2488	Alfonzo Hernandez
2892	Martin Fiero
3296	Lautaro Fernandez
3700	Alfonzo Hernandez
4104	Leonardo Castillo
4509	Juan Castro

Please let me know if that is clear.

Regards

[tamerj1]

Hi @Syndicate_Admin 

would you please request @ArgenisSuarez to advise the the expected results and to provide copy/paste version of the sample data?