Forum Discussion

pelowski's avatar
pelowski
Helper 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
Community 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
      Helper III
      8 years ago

      Yes!  That did it!  Thank you!

  • JQuon's avatar
    JQuon
    Helper 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?