Forum Discussion
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...
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.
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