DAX Calculate the Max for a Group

[scottkad]

Hello!  I have a problem and have a feeling a simple DAX formula can solve it. 

I would like the 'Desired Output' column to be the Max of the 'Check' column, evaluated for each Name. 

Any help is much appreciated, thanks. 

[ashishrj]

@scottkad You can use MAX() DAX expression. In your case Desired Output = MAX (TableName[Check]). Let me know if this is what you are looking for ! 

[scottkad · Accepted solution]

Thanks for the post ashishrj,

After many more google searches I was able to find this, Stack Overflow Calc Max

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

[Shmidtk]

But what you going to do if you have unsorted list? You can't really on ordering in general. Is there is way to do this without order dependence?