Forum Discussion
Sirhawk3017
Helper II
Helper IIWhy is ranking so hard / please help
Hi All, Why is it that rank works until I add the column license status. When I do this, then the rank functions wants to give ranks to each license status. I want an overall rank. FM ...
Hi Sirhawk3017 ,
Do you want to sort you visual by ID and status? I think ALLSELECTED is a good workaround.
FM Territory Rank 2 = RANKX(ALLSELECTED(FM_INFO[Agreement ID],FM_INFO[License Status]),[FM Sales YTD],,DESC,Dense)Rank 1 is FreemanZ's result and Rank 2 is mine. Please choose the measure which meet your requirement.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Sirhawk3017 ,
Do you want to sort you visual by ID and status? I think ALLSELECTED is a good workaround.
FM Territory Rank 2 = RANKX(ALLSELECTED(FM_INFO[Agreement ID],FM_INFO[License Status]),[FM Sales YTD],,DESC,Dense)
Rank 1 is FreemanZ's result and Rank 2 is mine. Please choose the measure which meet your requirement.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Sirhawk3017Helper II
Helper IIa million times thank you!