Forum Discussion

burnaNayak's avatar
burnaNayak
Regular Visitor
5 years ago
Solved

RANKX Function

Hi ,   I Have applied Ranx to my Table which looks as below . In the first snapshot below have grouped the countries to show the Sales amount in Desc Order . CountryRank = RANKX(ALLSELECTED(user_...
Need Help
  • CNENFRNL's avatar
    CNENFRNL
    5 years ago

    Hi, burnaNayak , strange enough😂 it's works at my side. I attached a file for your further reference.

CNENFRNL's avatar
CNENFRNL
Community Champion
5 years ago

Hi, burnaNayak , you're only one inch away from your goal.

But there's a glitch in your measure, which throws error in such a viz

 

Therefore, I amend it and author another measure to achieve the goal as you described.

CountryRank amended = 
RANKX (
    ALLSELECTED ( user_first_deposit ),
    CALCULATE ( SUM ( user_first_deposit[usd_amount] ) )
)

////////////////////
TOP4 = IF( [CountryRank amended] <= 4, MAX(user_first_deposit[country]), "Other")
  • burnaNayak's avatar
    burnaNayak
    Regular Visitor
    5 years ago

    Hi , 

    If I add the countryrankamended , it looks like the 1st snapshot 

    But once i add the Top 4 column , the 2nd snapshot changes as below and is not giving me what i expected .

    1st Snapshot 

     

     

    2nd Snapshot 

     

     

     

     

    • CNENFRNL's avatar
      CNENFRNL
      Community Champion
      5 years ago

      Hi, burnaNayak , strange enough😂 it's works at my side. I attached a file for your further reference.