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])))

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