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] )
v-luwang-msft's avatar
v-luwang-msft
Community Support
5 years ago

Hi raymond ,

You could try the following measure:

Measure = CALCULATE(MAX('Table'[Max value A])+MAX('Table'[Max value B])+MAX('Table'[Max value C]),FILTER(ALL('Table'),'Table'[Country]=MAX('Table'[Country])))

 

base  data:

 

And final output:

Wish it is helpful for you!

 

Best Regards

Lucien