Forum Discussion

Catsupgirl57's avatar
Catsupgirl57
New Member
3 years ago

Rankx function in table visualization not carrying over to card visualization

I am currently using this function in my table to understand the ranking of key brands based on sales:

 

Rank = RANKX(ALLSELECTED(Table(Brand) , CALCULATE(SUM(Table ($))
 
I can get it to work for the table with the slicers, but there is one brand I want to have a callout for at all times using the card function, but when I pull the rank over and filter to that brand, it goes to 1. How do I get the rank # to transfer over to the card? I've also tried to create a static formulation that is not working; the 'dense' function isn't recognized.
Need Help

2 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    3 years ago

    Hi,

    Instead of using ALLSELECTED DAX function, try using ALL DAX function whether it suits your requirement.

     

     Rank = RANKX(ALL(Table(Brand) , CALCULATE(SUM(Table ($))

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    3 years ago

    Hi,

    Since there is no row context in a card visual, I don't think you can get a rank in a card visual.