Thank you for this. It helps but it's only scratching the surface and rarely will there be a use case where a single, non-dynamic rank is necessary. Would be more helpful to include how to aggregate rank by month or some other date interval. Love your work; just think this needs more color.
Great video! question : if i create a dynamic top 10 bottom 10 table which is linked to a slicer to display, i have my Bottom part skipping a Rank for the Zeros it seems. because of i choose to display bottom 5, it actually displays bottom 4,if i choose bottom 10 it will display bottom 9 and so on... any suggestions?
rankx(ALL(VW_NAV[Fund_Name]),CALCULATE('VW_NAV'[Return_PTP]),,DESC,Dense) Hello. By implementing the above DAX , my rank is skipping by 1 when the values become negative ( eg - 1 2 4 5 6) . Can you pls help me