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] )
selimovd's avatar
selimovd
Most Valuable Professional
5 years ago

Hey raymond ,

 

the following should work:

 

 

New Column = CALCULATE( MAX( myTable[Max Value A] ), ALLEXCEPT( myTable, myTable[City] ) ) + CALCULATE( MAX ( myTable[Max Value B] ), ALLEXCEPT( myTable, myTable[City] ) ) + CALCULATE( MAX ( myTable[Max Value C] ), ALLEXCEPT( myTable, myTable[City] ) )

 

 

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis