Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Check highest value for multiple fields

I'm working on a requirement to find the highest value out of the Quarter & Name using a Result value to check. I've managed to get it to work to an extent, by which it looks at the highest value per...
  • mahoneypat's avatar
    mahoneypat
    6 years ago

    Please try this approach

     

    IsHighest =
    VAR thisresult =
    SUM ( Table1[Result] )
    VAR quartermax =
    MAXX ( ALLSELECTED ( Table1[Quarter] ), CALCULATE ( SUM ( Table1[Result] ) ) )
    RETURN
    IF ( thisresult = quartermax, 1, 0 )

     

     

    If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

    Regards,

    Pat

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

Please try this approach

 

IsHighest =
VAR thisresult =
SUM ( Table1[Result] )
VAR quartermax =
MAXX ( ALLSELECTED ( Table1[Quarter] ), CALCULATE ( SUM ( Table1[Result] ) ) )
RETURN
IF ( thisresult = quartermax, 1, 0 )

 

 

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    That's the one, legend!