Forum Discussion

Omarb33's avatar
Omarb33
Regular Visitor
2 years ago

Issue when filtering with RANQX

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!

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    2 years ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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