LOOKUPVALUE that matches two criteria for multiple lines

[nesselman]

I'm trying to use LOOKUPVALUE using DATA TABLE for Person and ComboCategory to get Avg Days (and then later Potential and Accuracy).

I end up with "A single value for column "ComboCategory" in table DATA TABLE can not be determined." error.

Objective is for each line in Data Table to grab any of the three variables (Avg Days, Potential, or Accuracy) in Lookup Table.  Either as a measure or a column to use with Data Table.

[Greg_Deckler]

@nesselman You can use MAXX(FILTER(...),...) as a replacement for LOOKUPVALUE or even CONCATENATEX(FILTER(...),...)