MAX Filter gives me Minimum Value

[Anonymous]

Hi,

I have a table with the amount of visits per supermarket. I want to show the max supermarket with the most visits in a Card. 

I'll use this DAX code: 

Max Measure = MAX(Milka[keten])

Outcome: 

Can someone help me?

[Fowmy · Accepted solution]

@Anonymous 

Please this measure

Max Measure = 

var __t = 
    TOPN(1, ADDCOLUMNS(SUMMARIZE(Milka,Milka[keten]),"@number", CALCULATE(COUNTROWS(Milka))),[@number])
return
    MAXX( __t, Milka[keten])

[Anonymous]

Thank you so much!