topic Re: LOOKUPVALUE missing identical lookups in DAX Commands and Tips

LOOKUPVALUE missing identical lookups

Anonymous — Mon, 21 Aug 2023 12:51:53 GMT

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])

Re: LOOKUPVALUE missing identical lookups

Greg_Deckler — Mon, 21 Aug 2023 13:21:39 GMT

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

Re: LOOKUPVALUE missing identical lookups

Anonymous — Mon, 21 Aug 2023 13:37:18 GMT

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.

Re: LOOKUPVALUE missing identical lookups

Anonymous — Tue, 22 Aug 2023 06:10:08 GMT

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