Forum Discussion

sophie-burgess's avatar
sophie-burgess
Regular Visitor
7 months ago
Solved

RANKX Formula duplicating ranks when value is the same

Hey team,   I have been trying for hours to get my RANKX formula to work but to no avail.   What I need is for my RANK measure to rank my group names by my YTD amount measure. I used the below fo...
Need Help
  • sophie-burgess's avatar
    sophie-burgess
    7 months ago

    Hey everyone,

     

    Thanks for the help but I've managed to find a solution by reading up on some articles, below was all I needed to do:

    Rank =
    RANK (
        DENSE,
        ALLSELECTED ( 'bcs vw_pbi_sales_detail'[Group Name] ),
        ORDERBY ( [YTD Amount], DESC, 'bcs vw_pbi_sales_detail'[Group Name], ASC )
    )
     
    Thanks
sophie-burgess's avatar
sophie-burgess
Regular Visitor
7 months ago

Hey everyone,

 

Thanks for the help but I've managed to find a solution by reading up on some articles, below was all I needed to do:

Rank =
RANK (
    DENSE,
    ALLSELECTED ( 'bcs vw_pbi_sales_detail'[Group Name] ),
    ORDERBY ( [YTD Amount], DESC, 'bcs vw_pbi_sales_detail'[Group Name], ASC )
)
 
Thanks