Forum Discussion

meduza's avatar
meduza
Frequent Visitor
2 years ago
Solved

TOP10

Hello, I have table with clients and all orders details, when I count orders (measure), i got clients with amount of orders, when i do filter, top10, i can get this ... but I want to have table sam...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi meduza ,

     

    It seems to work on this table as well.If you need to create another calculation sheet, please talk to me:

     

    Hope it helps!

     

    Best regards,
    Community Support Team_ Scott Chang

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

     

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi meduza ,

 

I made simple samples and you can check the results below:

Top2 = var _t = ADDCOLUMNS('Table',"Rank",RANKX(ALL('Table'),[count],,DESC,Dense))
RETURN COUNTAX(FILTER(_t,[Rank]<=2),[count])

 

An attachment for your reference. Hope it helps!

 

Best regards,
Community Support Team_ Scott Chang

 

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.