TOP10

[meduza]

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 same like before with all details, just with this TOP10 clients....

I cant make it with TOPN or summarize, because when i  dont get all info i want

I want same table,  but to see only top10 clients info..... how can i do without filter? because when i put slicer... i see all info..
Thanks for any advice

[meduza]

Hello @v-tianyich-msft ,
thank you for try and reply, but it is not what i need... I will try again to explain:

example we have like this table: 

After ranking we see TOP10 (yellow)

And finally I want to have seperate table with only this TOP10, same table with same columns.

How can I do this please with DAX?

[v-tianyich-msft · Accepted solution]

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.

[v-tianyich-msft]

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.

[meduza]

@Daniel29195 
See example of my table, we have 15 client, but i want to have TOP10 client by count of orders, and to have table only with TOP10 client, and to work with them.
TABLE with TOP10 clients and to see all info like we saw before, just to ignore clients which are not top10... If i do this on visual filter topn... when i put slicer from table... i see also other clients... 

[Daniel29195]

@meduza 

can you share a visual representation of your requirement .