Top month per category

[badger123]

Hello, I'm trying to create a measure to calculate the top month per ID per country baesd on the value.

Desired output:

ID	Country	Top Month
A	UK	June
B	UK	October
A	US	July
B	US	December

Table:

ID	Country	Month	Value
A	UK	January	10
A	UK	February	10
A	UK	March	10
A	UK	April	10
A	UK	May	10
A	UK	June	20
A	UK	July	10
A	UK	August	10
A	UK	September	10
A	UK	October	10
A	UK	November	10
A	UK	December	10
B	UK	January	10
B	UK	February	10
B	UK	March	10
B	UK	April	10
B	UK	May	10
B	UK	June	10
B	UK	July	10
B	UK	August	10
B	UK	September	10
B	UK	October	20
B	UK	November	10
B	UK	December	10
A	US	January	10
A	US	February	10
A	US	March	10
A	US	April	10
A	US	May	10
A	US	June	10
A	US	July	20
A	US	August	10
A	US	September	10
A	US	October	10
A	US	November	10
A	US	December	10
B	US	January	10
B	US	February	10
B	US	March	10
B	US	April	10
B	US	May	10
B	US	June	10
B	US	July	10
B	US	August	10
B	US	September	10
B	US	October	10
B	US	November	10
B	US	December	20

[Zubair_Muhammad · Accepted solution]

@badger123 

Try thie MEASURE

Measure =
CONCATENATEX (
    TOPN ( 1, Table1, CALCULATE ( VALUES ( Table1[Value] ) ), DESC ),
    [Month]
)