Forum Discussion

jackj's avatar
jackj
Helper I
5 years ago

Create a Static Ranking Card Visual from a measure

All,   I am trying to create a Card Visual showing the rank of sales values in a given week based on a measure, "Net Sales", which is being filtered on the page by two items - the store location (C...
Need Help
Tips and Tricks
parry2k's avatar
parry2k
Super User
5 years ago

jackj share your ranking measure to take a look at it.

  • jackj's avatar
    jackj
    Helper I
    5 years ago
    RANK MEASURE =
    RANKX ( ALLSELECTED ( 'warehouse Stores'[DBA] ), [Net Sales],, DESC, DENSE )
    • mdarlington's avatar
      mdarlington
      Frequent Visitor
      2 years ago

      I am having the exact same issue.  Did you manage to get this solved?

  • jackj's avatar
    jackj
    Helper I
    5 years ago

    Hmm.  I changed the DAX to 

    RANK MEASURE =
    RANKX ( ALL ( 'warehouse Stores'[DBA] ), [Net Sales],, DESC, DENSE ), but it still shows "1" in the visual.  I ensured that interactions with the slicer are turned off. 
     
     
    • v-janeyg-msft's avatar
      v-janeyg-msft
      Community Support
      5 years ago

      Hi, jackj 

       

      Have your problem solved? There is no problem with the formula, it's not very clear what the context of your measure is. Can you share a sample fake file? So we can make a workaround for you.

       

      Best Regards

      Janey Guo