Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago
Solved

Extract Certain Users

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 no...
  • tamerj1's avatar
    tamerj1
    4 years ago

    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
tamerj1's avatar
tamerj1
Community Champion
4 years ago

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