PowerPivot Calculating Max of column

[txfrazier]

Hello,
I'm trying to calculate the maximum number in one column (Col 3) based on the common values in another column (Col 1). Example given. Thanks for your help.

 

[Chihiro]

Do you need it as measure or calculated column?

I don't have PowerPivot at work.
But, typically you'd use FILTER as criteria in calculation.

= CALCULATE(MAX(Tabel1[Col3]), FILTER(Table1, Table1[Col1] = "xxxx"))

 

[txfrazier]

Thanks. I'm trying to create a calculated column. I tried your suggestion but it only returned BLANK. Should I use something besides "xxxx" at the end of the formula? I removed the "xxxx" and it returned the largest number in the whole table for col 3.

 

[Chihiro]

Yes, replace with your condition.

Something like...
=CALCULATE(MAX(Table1[Col3]),FILTER(Table1,Table1[Col1]=EARLIER(Table1[Col1])))

 

[txfrazier]

Works perfectly!!! Thanks so much!!!