Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Filter on specific Rankx value for card visual

I have the blow formula which correclty ranks these 5 rows.  In total I have about 100 rows, but the screenshot is just showing the top 5.  You'll see why...   USD Market Cap Rank = RANKX(ALL(Coin...
Rankx with filter
  • VahidDM's avatar
    VahidDM
    5 years ago

    Hi Anonymous 

     

    Try this to find the Ranking:

     

    USD Market Cap Rank = RANKX(all(CoinMarketCap),CoinMarketCap[Total USD Market Cap],,DESC,Dense)

     

    If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

    Appreciate your Kudos!!

     


     
VahidDM's avatar
VahidDM
Icon for Super User rankSuper User
5 years ago

Hi Anonymous 

 

Try this to find the Ranking:

 

USD Market Cap Rank = RANKX(all(CoinMarketCap),CoinMarketCap[Total USD Market Cap],,DESC,Dense)

 

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!

 


 
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thank you!  This worked.  I changed ALL(CoinMarketCap[Crypto Name]) to ALL(CoinMarketCap) within the USD Market Cap Rank fomula like you stated and the update to this feed the individual Rank formulas and displayed correclty.  Thanks, again!