MAx value of a measure to return names of the respective value (country).

[Anonymous]

Hi There,

I want dax measure to return the names of the country which have the highest value. The value here is a measure itself.

I have used here a  trick of using a line chart and filtering on top n as 1, but this give only 1 country as max, if i have more than 1 countries- how can i get that?

Thanks!

[tamerj1 · Accepted solution]

Hi @Anonymous 
You can try

Max Country =
VAR T1 =
    ADDCOLUMNS ( VALUES ( TableName[Country] ), "@Value", [Measure] )
VAR MaxValue =
    MAXX ( T1, [@Value] )
VAR MaxRecord =
    FILTER ( T1, [@value] = MaxValue )
RETURN
    MAXX ( T1, [Country] )