Table TOPn name

[Anonymous]

Hello,

I´ve the Table1, and I need to create a new calculated table "Final Table" ( only the name of the camp Prod), but with the top 1 for each Region:

Thanks.

[Ashish_Mathur]

Hi,

Why do you want only 1 column in the Final Table.  Wouldn't you also want to see the Product and Region?

[amitchandak · Accepted solution]

@Anonymous , Ideally you should use Rank/TOP/index and a visual table.

but for calculated table try like

selectcolumns(filter(addcolumns(Table, "_Rank", Rankx(filter(Table, [Region] = earlier([region]) ), [Sales],,desc,dense) ),[_Rank] =1), [Product])

Index function: Top/Bottom Performer by name and value- https://youtu.be/HPhzzCwe10U