Help with calculating minimum value

[sromondas]

Hello,

i have my data structured in the following manner (this is just a simplified version of what my table looks like):

Month	Country	Score
Jan	US	5
Feb	US	6
Jan	Canada	7
Feb	Canada	9
Jan	Germany	4
Feb	Germany	1

I'm trying to calculate, in a new column, the minimum score for each country. So, the result should look something like this:

Month	Country	Score	Country's Min Score
Jan	US	5	5
Feb	US	6	5
Jan	Canada	7	7
Feb	Canada	9	7
Jan	Germany	4	1
Feb	Germany	1	1

Many thanks

[tamerj1 · Accepted solution]

Hi @sromondas 

CALCULATE ( MIN ( 'Table'[Score] ), ALLEXCEPT ( 'Table', 'Table'[Month], 'Table'[Country] ) )

[sromondas]

Appreciate the quick response. thanks!