Forum Discussion

ibuhary's avatar
ibuhary
Icon for Helper I rankHelper I
7 years ago
Solved

RANKX

Hello there, I have a table with Store ID, Store Name and Sales. I have created a measure to Rank the Store Names based on highest sales. StoreRank = RANKX(ALLSELECTED( 'Table'[Store Name])...
Need Help
  • sokg's avatar
    sokg
    7 years ago

    Not in my test data. See pic below

     

sokg's avatar
sokg
Icon for Solution Supplier rankSolution Supplier
7 years ago

Why do you use ALLSELECTED instead of ALL???

Why do you use 'Table'[Store Name] instead of just 'Table'???

 

so try this

 

StoreRank =
RANKX ( ALL ( Table ), CALCULATE ( SUM ( 'Table'[Sales] ) ),, DESC )
  • ibuhary's avatar
    ibuhary
    Icon for Helper I rankHelper I
    7 years ago

    In that case the ranks returned are all 1 for all the stores

    • sokg's avatar
      sokg
      Icon for Solution Supplier rankSolution Supplier
      7 years ago

      Not in my test data. See pic below

       

      • ibuhary's avatar
        ibuhary
        Icon for Helper I rankHelper I
        7 years ago

        Actually I have a larger database, but I cut it short to ask the question.

         

        Is it possible to send it to you to check what I am doing wrong ?