return label from Column A for summarized column B

[mrothschild]

I have data similar to the following:

Country	City	Location	Number
USA	NY	A	10
USA	LA	B	65
USA	LA	C	65
UK	London	D	60
UK	London	E	60
UK	Brighton	F	60

Using this code I'm able to get to the MAXIMUM by Country or City:

VAR Exposure =      MAXX(
                        DISTINCT('Table 1'[Country]),
                        CALCULATE(SUM('Table 1'[Number]))
                    )

RETURN 

Exposure

Now I'd like to return the Country associated with [Exposure]

Thanks!

[mrothschild]

@Fowmy Thanks so much!  Works perfectly!

[Fowmy · Accepted solution]

@mrothschild 

Returns the country with the largest value:

Country Max = 

var __t = 
    TOPN(1, ADDCOLUMNS(SUMMARIZE(table1,Table10[Country]),"@number", CALCULATE(SUM(table1[Number]))),[@number])
return
    MAXX( __t, table1[Country])