Forum Discussion

GilesWalker's avatar
GilesWalker
Skilled Sharer
10 years ago
Solved

Set a filter based on MAX

Hi Everyone,   I have tried a number of different equations and have looked through Google to no avail. I have some data I need to be able to filter based upon the maximum number in a column, howev...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    10 years ago

    GilesWalker - Try switching your ALL to an ALLEXCEPT in order to preserve the Train ID context filter:

     

    max = CALCULATE(MAX(Train_Movements[sequence]),ALLEXCEPT(Train​_Movements,[Train id]))
Greg_Deckler's avatar
Greg_Deckler
Community Champion
10 years ago

GilesWalker - Try switching your ALL to an ALLEXCEPT in order to preserve the Train ID context filter:

 

max = CALCULATE(MAX(Train_Movements[sequence]),ALLEXCEPT(Train​_Movements,[Train id]))
GilesWalker's avatar
GilesWalker
Skilled Sharer
10 years ago

Greg_Deckler You are a legend. Thank you for sorting this out for me. Are you able to explain how the formula works with the ALLEXCEPT?

 

Thanks,

 

Giles