Using DAX to filter a person with MAX money?

[Anonymous]

Hi, 

I want to create a tooltip that shows a person with the most money: 

Bananas	Erik	13$
Bananas	Adam	15$
Bananas	Josh	11$
Apples	Erik	9$
Apples	Adam	3$

The tooltip should show the following:

• after hovering over Bananas the name Adam (15$) would be shown
• after hovering over Apples the name Erik (9$)

I imagine it has to do something with MAX function, any ideas on how to achieve this? 

[FrankAT · Accepted solution]

Hi @Anonymous ,

give this a try:

Max Amount =
VAR _Table =
    FILTER (
        ALLEXCEPT ( 'Table', 'Table'[Fruit] ),
        'Table'[Amount] = MAX ( 'Table'[Amount] )
    )
RETURN
    MAXX ( _Table, 'Table'[Name] ) & " ("
        & MAXX ( _Table, 'Table'[Amount] ) & "$ )"

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)