Find my approach based on Lookup-functionality as reference below and stored in attached workbook version 10.5 located in the original thread.
1. M1. Lookup: LOOKUP(sum([Value]),-1)
2. M2. Display: if sum([Value])>[M1. Lookup] then 'Bid' END
Hope it helps,
lookup nalmai_v10.5.twbx 75.8 KB