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

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.