Not sure if I understand your challenge but find my approach as reference below and stored in attached workbook version 10.5 located in the original thread.
1. M1. Lookup: lookup(min([Value]),-1)
2. M2. 1 or 0: if sum([Value]) >= [M1. Lookup] then 1 else 0 end
3. Drag the required objects to the indicated locations and show filter
Hope it helps,
lookup nalmai v10.5.twbx 33.2 KB
thanks Norbert, i did the same calculations in my example in my first post...
if you look at the data source tab, you will see there is not a row level calculation , because of the table calculation (LOOKUP) it is an aggregate...
i want a row level calculation not an aggregation... is there anyway to write this as a row level calculation and not as an aggregate (table calc)?