LOOKUPVALUE missing identical lookups

[pasele]

Hello can someone help me. Why are more than half of the values missing from this simple vlookup. If one works they should all work. I even use trim function in wbs_blank_fix. My lookup table for this code only has 1 row 

COSTCENTER_fix = LOOKUPVALUE('sapdata SAP_projektelement'[Ansvarigt_kostnstl], 'sapdata SAP_projektelement'[WBS_element], 'sapdata SAP_costcalculationplan'[wbs_blank_fix])

[Greg_Deckler · Accepted solution]

@pasele LOOKUPVALUE will "fail" if there are multiple matches. Try using MAXX( FILTER( ... ), ... ) instead.

[pasele]

Update MAXX indeed did the trick and fixed my issues, thanks for the help

[pasele]

Okay will try tomorrow, but I will add this project code is unique in the lookup table and I already used this lookup successfully in another table in the same model. So it is very wierd to me.