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] )
Nathaniel_C's avatar
Nathaniel_C
Community Champion
5 years ago

Hi raymond ,
What is your logic that Germany's sum is 3 and not 4?

 

raymond's avatar
raymond
Post Patron
5 years ago

Thank you.

I want to find out how many values generally occur for each country. In Germany only 3 attributes or traits occur. 

 

Think of it 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.