Forum Discussion

pelowski's avatar
pelowski
Icon for Helper III rankHelper III
8 years ago
Solved

DAX Formula - Return a calculated column MAX after grouping multiple other columns

I know this should be easy but despite trying and trying different options and searching for a couple hours, I can't get this to work.   As an example, I have scores in a table like this...   ...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Hi pelowski

     

    Try this Column

     

    MyMax =
CALCULATE (
    MAX ( Scores[Score] ),
    ALLEXCEPT ( Scores, Scores[Date], Scores[Court], Scores[Game] )
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

Hi pelowski

 

Try this Column

 

MyMax =
CALCULATE (
    MAX ( Scores[Score] ),
    ALLEXCEPT ( Scores, Scores[Date], Scores[Court], Scores[Game] )
)
  • pelowski's avatar
    pelowski
    Icon for Helper III rankHelper III
    8 years ago

    Yes!  That did it!  Thank you!