Forum Discussion
Dynamic ranking by sorted column
Hello! Let's say I've such table visual which is ranked by Volumes according formula Rank = RANKX(ALL(Organisations[Organisation]);[Volumes];;DESC;Dense) For example I want to sort Revenue co...
Thanks TomMartens. I solved my problem following this post: https://community.powerbi.com/t5/Desktop/Rank-a-column-in-a-table-based-on-slicer-selection/td-p/77705
Tomas
Hey,
I'm wondering if I understand correctly, but why not create just another measure like so:
Rank Revenue= RANKX(ALL(Organisations[Organisation]);[Revenue];;DESC;Dense)
Regards,
Tom
Thanks TomMartens. I solved my problem following this post: https://community.powerbi.com/t5/Desktop/Rank-a-column-in-a-table-based-on-slicer-selection/td-p/77705
Tomas