2
votes

Link to Table...

http://i.stack.imgur.com/hUVfc.png

I have a table with multiple repeated values associated with a certain group. I'm trying to scope out the max for each group, then sum it.

Answer needs to be 50 + 25 + 10 + 70

I've tried various SUMX and can't seem to get the filter correct.

Thanks,

1

1 Answers

2
votes

Maybe:

My Measure := SUMX(VALUES(Table1[Group]),CALCULATE(MAX(Table1[Value])))