Get min without getting the filtred value

[nkasdali]

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, like using ALL() fonction.

regrads

[Arentir · Accepted solution]

Hi @nkasdali

You can use calculate to ignore the filter context.

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

[nkasdali]

Thanks 🙂