Create a Static Ranking Card Visual from a measure

[jackj]

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 (Column "DBA") and the week (Column "FW Ending").  I am able to create a table showing the rank of the Net Sales for each store during the week when I select all stores in the page level slicer, but when I select a specific DBA location, it loses all of the ranking and simply returns a value of "1" for the store selected, even if that store is ranked, say, 33rd when I show the full table.  I want to be able to keep the ranking associated with the store when all locations are selected when I filter the page by individual stores. Is this possible?  Thanks in advance for any help.

[parry2k]

@mdarlington @jackj can someone put the sample data and what is the expectation?

[parry2k]

@jackj Ha! Change ALLSELECTED To ALL

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[parry2k]

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

[jackj]

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]

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

[jackj]

RANK MEASURE =

RANKX ( ALLSELECTED ( 'warehouse Stores'[DBA] ), [Net Sales],, DESC, DENSE )

[mdarlington]

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