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(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.

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

     


     

2 Replies

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