How to get the max value of a column from the table returned by GROUPBY

[lesliezhang]

Hi,

I have a table as below, and I want to create a measure for the max value after groupby [Category] and SUM([Value])

after GROUPBY, I can get below table. However, I don't know how to write the dax to get "9"

Please help

[az38 · Accepted solution]

Try this 

Measure = maxx(all('Table1');calculate(sum(Table1[Value]);Table1[Value]))

[lesliezhang]

Thank you very much. It works!