Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

Lookup Min/Max

This one or some variation of it comes up constantly in the forums so I'm surprised that there is no pattern in the Quick Measure Gallery for dealing with it. The problem generally goes along the lin...
Filters
Mathematical
Other
AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
3 years ago

Greg_Deckler Iterator X-functions are great but you can also do this without them.

Lookup Max = 
VAR _TopRow = TOPN ( 1, VALUES ( 'Table'[Item] ), CALCULATE ( SUM ( 'Table'[Value] ) ) )
VAR _TopItem = SELECTCOLUMNS ( _TopRow, "Item", 'Table'[Item] )
RETURN
    _TopItem