Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
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 ...
  • 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])))

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
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
Icon for Memorable Member rankMemorable 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])))

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Icon for Administrator rankAdministrator
    2 years ago

    thanks, it worked !!

    • dharmendars007's avatar
      dharmendars007
      Icon for Memorable Member rankMemorable Member
      2 years ago

      Hello Syndicate_Admin , 

      I was happy to help you...


      I request you to mark this as solution and give kudos.
       

      Thank You

      Dharmendar S

      LinkedIN