Issue when filtering with RANQX

[Omarb33]

Hello,

I have two tables in power BI. One table for stores and another one for reviews which are linked by a common store id.
I have created a table visual and added a rank to classify stores based on the average ranking and added also the number reviews in the rank formula to break ties.

When adding the rank measure in the table everything seems well as. However when I filter by rank (in visual filters) to show only top 20 stores, I have an issue as only 16 values appear. Why is there a mismatch and how can I solve this issue ? 

Your help will be much appreciated.
Many thanks!

[Anonymous]

Hi @Omarb33 

Can you provide your sample pbix file and the results you expect? So that I can help you better.  Please remove any sensitive data in advance.

Best Regards,

Jayleny

[amitchandak]

@Omarb33 , Try the new rank function it is better of to break ties

example

New Rank Desne = rank(DENSE, ALLSELECTED('PMP_GSA_itm_stats_v202312_stores'[Store]),ORDERBY([Average Rating],DESC,'PMP_GSA_itm_stats_v202312_stores'[Store] asc ))

Power BI - New DAX Function: RANK - How It Differs from RANKX: https://youtu.be/TjGkF44VtDo