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
Best rankx video I've found so far. thank you
saved my life! Thank you!
Glad it helped!
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.
Outstanding Boss
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?
How can use/take this rank in Card Visualization for specific product
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
Olá e possivel colocar uma medida ao lado dizendo onde houve empate?