Filter Top10 Rows with duplicate values

[Anonymous]

I want to show the top 10 rows based on the selected period filter.

But I won't able to active this by using the RANKX function or TOPN in Filter Panel.

Kindly Help me to Order by Desc based on Sales Quantity and Show only Top 10 Values in Bar chart.

[v-yiruan-msft]

Hi @Anonymous ，

Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem with you. Thank you.

Otherwise, you can create a measure as below and apply the filter on the visual with measure <=10.

Rank = 
RANKX (
    ALLSELECTED ( 'Table' ),
    CALCULATE ( SUM ( 'Table'[Sales Quantity] ) ),
    ,
    DESC,
    DENSE
)

Best Regards

[Anonymous]

This is Not working in My case, Because the Date Period is dynamically selected from the filter, So we need to Use Mesure kind of thinks. Above send link explained in changes in the table, not in mesures.

Kindly help me to fix this issue.

[amitchandak]

@Anonymous , refer rank tie breaker

Rank Tie breaker
https://community.powerbi.com/t5/Community-Blog/Breaking-Ties-in-Rankings-with-RANKX-Using-Multiple-Columns/ba-p/918655
https://databear.com/how-to-use-the-dax-rankx-function-in-power-bi/