Forum Discussion

GilesWalker's avatar
GilesWalker
Icon for Skilled Sharer rankSkilled 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
Icon for Community Champion rankCommunity 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]))