Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

2 Tables Validation - HELP

The goal is to identify the "Owner" of the ticket metrics we have from an external source.  We have almost gotten this with the script below, but are still having trouble with many showing "unassigne...
General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    8 years ago

    I have resolved this by doing this for each value and then Conatenate them together.

     

    RES1 = LOOKUPVALUE('Home Team Owners'[Owners],'Home Team Owners'[Hometeam],SELECTEDVALUE('IS Service Request  - Data List'[Home Team],"Unassigned"))

     

    RES1 = LOOKUPVALUE('Home Team Owners'[Owners],'Home Team Owners'[Hometeam],SELECTEDVALUE('IS Service Request  - Data List'[Home Team],"Unassigned"))

     

    RES3 = IF([RES2]=BLANK(),LOOKUPVALUE('Home Team Owners 4'[Owners],'Home Team Owners 4'[Hometeam],SELECTEDVALUE('IS Service Request  - Data List'[Assignments2],"Unassigned")))

     

    RES4 = IF([RES3]=BLANK(),LOOKUPVALUE('Home Team Owners 4'[Owners],'Home Team Owners 4'[Hometeam],SELECTEDVALUE('IS Service Request  - Data List'[Assignments2],"Unassigned")))

     

    RES1-2 = CONCATENATE([RES1], [RES2])

     

    RES1-2 = CONCATENATE([RES1], [RES2])

     

    ALL RES = CONCATENATE([RES1-2],[RES3-4])

     

    Manager = if([ALL RES]=BLANK(),"Unassigned",[ALL RES])

     

    This will also ensure that if there are any table changes then there will be no issues.

     

    Thank you for those who attempted to assist.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Anonymous,

 

Can you please share a sample pbix file for test? I think it will be help for coding formula.

 

Regards,

Xiaoxin Sheng

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      I have resolved this by doing this for each value and then Conatenate them together.

       

      RES1 = LOOKUPVALUE('Home Team Owners'[Owners],'Home Team Owners'[Hometeam],SELECTEDVALUE('IS Service Request  - Data List'[Home Team],"Unassigned"))

       

      RES1 = LOOKUPVALUE('Home Team Owners'[Owners],'Home Team Owners'[Hometeam],SELECTEDVALUE('IS Service Request  - Data List'[Home Team],"Unassigned"))

       

      RES3 = IF([RES2]=BLANK(),LOOKUPVALUE('Home Team Owners 4'[Owners],'Home Team Owners 4'[Hometeam],SELECTEDVALUE('IS Service Request  - Data List'[Assignments2],"Unassigned")))

       

      RES4 = IF([RES3]=BLANK(),LOOKUPVALUE('Home Team Owners 4'[Owners],'Home Team Owners 4'[Hometeam],SELECTEDVALUE('IS Service Request  - Data List'[Assignments2],"Unassigned")))

       

      RES1-2 = CONCATENATE([RES1], [RES2])

       

      RES1-2 = CONCATENATE([RES1], [RES2])

       

      ALL RES = CONCATENATE([RES1-2],[RES3-4])

       

      Manager = if([ALL RES]=BLANK(),"Unassigned",[ALL RES])

       

      This will also ensure that if there are any table changes then there will be no issues.

       

      Thank you for those who attempted to assist.