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