Forum Discussion

sromondas's avatar
sromondas
Frequent Visitor
3 years ago
Solved

Help with calculating minimum value

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 F...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi sromondas 

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

tamerj1's avatar
tamerj1
Community Champion
3 years ago

Hi sromondas 

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

sromondas's avatar
sromondas
Frequent Visitor
3 years ago

Appreciate the quick response. thanks!