How to get highest first, second . . . fifth value in a Column

[RanHo]

Good day!

           Can someone help me how to get the first , second until 10th highest value data in a column that will be using in Gauge visual jus like this one:

and also the maximum value is different from each other but I just get it on one column. How can I do that?

Thanks in advance.

-RanHo

[v-luwang-msft]

Hi @RanHo ，

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.If not ,pls share a sample data for your case.

Best Regards
Lucien

[RanHo]

@v-luwang-msft not yet, still working on it.

[RanHo]

@amitchandak thanks sir I'll try it.

[amitchandak]

@RanHo , Try measure  like

Rank Discount % = RANKX(all("Item"[Category]),[Discount %],,DESC,Dense)

2nd = calculate( [Rank Discount %], filter( value("Item"[Category]), [Rank Discount %] =2 ) )

or use maxx, sumx or averagex

maxx(filter( value("Item"[Category]), [Rank Discount %] =2 ), [[Rank Discount %])