DAX Calculation the Max for a Group

Question

I would like the 'Desired Output' column to be the Max of the 'Check' column.  I have a problem and have a feeling a simple DAX formula can solve it. 

Answer 1

You can try this out: 

Desired Output=CALCULATE(MAX([Check]),FILTER(Table1,[Name]=EARLIER([Name]))