Find rows ( or only a certain column from those rows) which have highest value of a specific column

Is it possible to achieve with a calculated measure? I’m able to do it in sql, but need the same in QuickSight caluclated measure:

select - SQL how to find rows which have highest value of specific column - Stack Overflow

If you just need to show the value in a visual (e.g. in a table), you don’t need to create a calculated field. Using the example in the link you provided, put MYINDEX in the “Group by” field well, NAME in the “Value” field well and select “Max” as your aggregation.

If you want a max value which is independent of any visual, you can create a calculated field like this:
maxOver({MYINDEX}, [{NAME}], PRE_AGG)

Take a look at level-aware calculations in the documentation:

1 Like

Hi @Eleri
Did David’s solution work for you? I am marking his reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community Q&A Forum!