Forum Discussion

DFPRO's avatar
DFPRO
Frequent Visitor
2 years ago
Solved

RANKX and Slicing

I have a data set that includes "Name" and "Count" as a dimension table, and a fact table containing these Names and many Scores. I also have several Dim.Tables for various metrics, such as "Employee...
Need Help
amitchandak's avatar
amitchandak
Super User
2 years ago

DFPRO , explore new rank and row number function, that will give better options for tie-breaker using order by

 

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

 

Power BI - New DAX Function: Rownumber- https://www.youtube.com/watch?v=yS9-IQjUDwg&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L&index=1

 

 

If needed you can use dynamic segmentation

 

Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1387187#M626


Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k

DFPRO's avatar
DFPRO
Frequent Visitor
2 years ago

Thank you, Amit. I recreated my first tie-breaking measure for Ranking by Name using Rownumber, then recreated all subsequent rank measures and it seems to work again. I don't know what broke it but thankful for the idea.