Forum Discussion

RanHo's avatar
RanHo
Icon for Helper V rankHelper V
4 years ago

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

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





Need Help
Show and Tell

4 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    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 %])

  • v-luwang-msft's avatar
    v-luwang-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    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