Filter only highest value by category

Hi Anonymous,

You'd better create calculated columns to get the max sale for each group, then create a new table to display what you want. I try to reproduce your scenario and get expected result as follows.

First, create a calculated column using the following formula.

Max = CALCULATE(MAX(Test[Sales]),ALLEXCEPT(Test,Test[Group]))

Then click the New table under Modeling, type the DAX and create a new table. Please the result in screenshot, the result table will refresh when your data refresh.

Expected result = SELECTCOLUMNS(FILTER(Test,Test[Sales]=Test[Max]),"Group",Test[Group],"Sales Person",Test[Sales Person],"highest",Test[Max])

If you have any other issue, please feel free to ask.

Best Regards,
Angelia