Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago
Solved

SUMMING MAXIMUM VALUES IN TABLE

Hello, I have the following table with maximum values, but in the total sum, instead of getting 369, for example, in this case I get the highest value of the column, that is, 147.

The formula I'm using to calculate ACTUAL MO is:

CURRENT MO = SUMX(VALUES('Ago 24'[DATE]),CALCULATE(MAX('Ago 24'[MO])))
Can anyone help me?
  • dharmendars007's avatar
    dharmendars007
    2 years ago

    Please use the below measure..I assume the column is "Tipo Area", if not please replace the right column names which is used in the visual

    If(Hasonefilter(Ago 24[Tipo Area]),
    CALCULATE(MAX('Ago 24'[MO])), 
    SUMX(VALUES('Ago 24'[Tipo Area]),CALCULATE(MAX('Ago 24'[MO])))

5 Replies

  • dharmendars007's avatar
    dharmendars007
    Memorable Member
    2 years ago

    Hello Syndicate_Admin , 

    You can tweak your measure like the below..

    CURRENT MO = 

    If(Hasonefilter(Ago 24[DATE]),
    CALCULATE(MAX('Ago 24'[MO])), 
    SUMX(VALUES('Ago 24'[DATE]),CALCULATE(MAX('Ago 24'[MO])))

    If you find this helpful , please mark it as solution and give kudos
     

    Thank You

    Dharmendar S

    LinkedIN





  • Syndicate_Admin's avatar
    Syndicate_Admin
    Administrator
    2 years ago

    Thank you for the prompt response.

    But I still get the maximum value in the total, that is, 147

    Use the formula directed:

    Measure 2 = if(hasonefilter('Ago 24'[DATE]),
    CALCULATE(MAX('Ago 24'[MO])),
    SUMX(VALUES('Ago 24'[DATE]),CALCULATE(MAX('Ago 24'[MO]))))
    • dharmendars007's avatar
      dharmendars007
      Memorable Member
      2 years ago

      Please use the below measure..I assume the column is "Tipo Area", if not please replace the right column names which is used in the visual

      If(Hasonefilter(Ago 24[Tipo Area]),
      CALCULATE(MAX('Ago 24'[MO])), 
      SUMX(VALUES('Ago 24'[Tipo Area]),CALCULATE(MAX('Ago 24'[MO])))