Forum Discussion

itchyeyeballs's avatar
itchyeyeballs
Impactful Individual
9 years ago
Solved

SumX using max

Hi all,    I'm having an issue with using SumX and can't figure out what I'm doing wrong (the 'X' functions always trip me up)   I'm trying to calculate the sum of the maximum values accross grou...
Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    itchyeyeballs

     

    hi, just add a Calculate in Max.

     

    Measure 2 =
IF (
    HASONEVALUE ( Table1[col2] ),
    MAX ( Table1[Value] ),
    SUMX ( VALUES ( Table1[Col2] ), CALCULATE ( MAX ( table1[value] ) ) )
)
Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

itchyeyeballs

 

hi, just add a Calculate in Max.

 

Measure 2 =
IF (
    HASONEVALUE ( Table1[col2] ),
    MAX ( Table1[Value] ),
    SUMX ( VALUES ( Table1[Col2] ), CALCULATE ( MAX ( table1[value] ) ) )
)
itchyeyeballs's avatar
itchyeyeballs
Impactful Individual
9 years ago

Perfect, thank you!

  • OwenAuger's avatar
    OwenAuger
    Super User
    9 years ago

    A side note:

    You can also get rid of the HASONEVALUE test, since if Col2 has one value then SUMX will iterate over that one value anyway:

     

    =
SUMX ( VALUES ( Table1[Col2] ), CALCULATE ( MAX ( table1[value] ) ) )