Forum Discussion

nkasdali's avatar
nkasdali
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago
Solved

Get min without getting the filtred value

Hi all,   Please, i'm writting in a measure with a variable =MIN(YEAR). But, when i select a value in my Year slicer, the MIN will take my slicer value. How can i do to get the MIN of my year, lik...
Need Help
Tips and Tricks
  • Arentir's avatar
    Arentir
    8 years ago

    Hi nkasdali

    You can use calculate to ignore the filter context.

    Measure = CALCULATE(MIN(Date[Year]), ALL(Date))

Arentir's avatar
Arentir
Icon for Resolver III rankResolver III
8 years ago

Hi nkasdali

You can use calculate to ignore the filter context.

Measure = CALCULATE(MIN(Date[Year]), ALL(Date))

nkasdali's avatar
nkasdali
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Thanks :)