Total of Maximum in Matrix from multiple rows

[JarodSchultz]

I have a matrix that is made of data that is coming from 2 servers. The "values" field is set to "maximum" so I can see what the largest value is from the data set based on year, quarter, month, and day. I want the total to show the sum of the 2 maximum values instead it reporting the highest of the 2 values as a total.

[mahoneypat · Accepted solution]

You should make a measure instead of using the implicit measures created by dragging a column into the field well.  Here is one that should work.

NewMeasure = SUMX(VALUES(Table[Server]), CALCULATE(MAX(Table[Column])))

Replace Table with your actual table name (the same column used in your visual), and replace column with the column used in your max calculation.

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[JarodSchultz]

Thank You!

[JarodSchultz]

Here is an example of someone else that did it but not understanding how they arrived to the solution. https://community.powerbi.com/t5/Desktop/Set-values-as-Maximum-but-want-to-have-the-grand-total-sum-...