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] )
raymond's avatar
raymond
Post Patron
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] )