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] )
)
JQuon's avatar
JQuon
Icon for Helper I rankHelper I
8 years ago

I'm also looking to do the same and this solution almost gets me there.  Is it possible to only show the max value in the row that has the value and leave the remaining blank?  For Example in the section in the blue box, Is it possible to show the highest score of 18 only in the row that has the score of 18 and leave the other rows blank?