Filtering monthly sales as per the top 10 customers

[sekinod]

How can I get the values of the monthly sales as per the top 10 customers.

[amitchandak]

@sekinod , You can create a rank like this and filter <=10 in the visual level filter

rankx(filter(allselected(Table, Table[month Year],Table[Customer]), Table[month Year] =max(Table[month Year])),[sales])

For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/3...

Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.

[Anonymous]

@sekinod  Hey Mate ,

You can use this .

In this scenario, I think you can firstly create a calculated column for RANK:

RANK=
RANKX(ALL(Table), SUMX(Table, Table[Sales]))

Then create a display name column based on this RANK column:

DISPLAY_CUSTOMER=
IF(Table[Rank]>10,"Other",Table[Customer])

Now you just need to drag the DISPLAY_CUSTOMER column into your table visual, all the "Other"s will be aggregated.