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 bas...
Need Help
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