Forum Discussion

raymond's avatar
raymond
Post Patron
5 years ago
Solved

SUM the MAX Values

Hi everyone,   I browsed through several topics but couldnt find an answer...so I am writing now 🙂   I have a Matrix with several Max Values. The Matrix has the granularity of "City". However, I...
Need Help
  • raymond's avatar
    raymond
    5 years ago

    I have found a solution on my own. It was after all more simple than I have initially thought.

    Value = 
MAXX( TABLE ,TABLE[Max value A] ) +
MAXX( TABLE ,TABLE[Max value B] ) +
MAXX( TABLE ,TABLE[Max value C] )
amitchandak's avatar
amitchandak
Super User
5 years ago

raymond , If Max Value A , MAx Value B are column values not measure

then try

sumx(summarize(Table, Table[country], Table[city], "_1", CALCUALTE(Max(Table[Value]))), [_1])

  • raymond's avatar
    raymond
    Post Patron
    5 years ago

    Thank you amitchandak and Nathaniel_C but unfortunately this wasnt working the way it was intended.

     

    Think of the values in the columns as people with blond, brunette and black hair. Hence in Germany we have 3 hair types and not 4. In Munich we have 1 hair type.