Filter on specific Rankx value for card visual

[abelmendibles]

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(CoinMarketCap[Crypto Name]), [Total USD Market Cap])

Now I want to create a card for each of the top 5 and display the Market Cap amount.  I'm trying to put the market cap for the #1 ranking in 1 card.  The market cap for the number 2 ranking in a separate card.  The market cap for the number 3 ranking in a separate card, and so forth up to 5 dards.  Here's what I'm getting:

Rank 1 = CALCULATE(MeasuresTable[Total USD Market Cap], FILTER(CoinMarketCap,[USD Market Cap Rank] = 1))

I know why I'm getting the above, its becuase it's taking the complete total for all my rows in the data.  

This is my DAX measure for card number 2, I'm trying to filter on just ranking 2, but get no results:

Rank 2 = CALCULATE(MeasuresTable[Total USD Market Cap], FILTER(CoinMarketCap,[USD Market Cap Rank] = 2))

Any ideas on how I can correct my DAX measure to filter on a specific rank value?  The reason I want to filter on a specific ranking is beause as the rankings change, I want the cards to by dynamic and move the ranked items around between the 5 cards.  Thank you.

[VahidDM · Accepted solution]

Hi @abelmendibles 

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!!

[abelmendibles]

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!