Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
jackj
Helper I
Helper I

Create a Static Ranking Card Visual from a measure

‎02-09-2021 02:47 PM

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.

Labels:
Message 1 of 8
763 Views
0
7 REPLIES 7
parry2k
Super User
Super User

‎10-06-2023 09:43 AM

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



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Message 8 of 8
220 Views
0
parry2k
Super User
Super User

‎02-09-2021 03:25 PM

@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.⚡



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Message 7 of 8
715 Views
0
parry2k
Super User
Super User

‎02-09-2021 02:56 PM

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



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Message 2 of 8
757 Views
0
jackj
Helper I
Helper I
In response to parry2k

‎02-11-2021 08:27 AM

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. 
 
 
Message 5 of 8
659 Views
0
v-janeyg-msft
Community Support
Community Support
In response to jackj

‎02-18-2021 02:33 AM

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

 

 

Message 6 of 8
633 Views
0
jackj
Helper I
Helper I
In response to parry2k

‎02-09-2021 03:23 PM
RANK MEASURE =
RANKX ( ALLSELECTED ( 'warehouse Stores'[DBA] ), [Net Sales],, DESC, DENSE )
Message 3 of 8
733 Views
0
mdarlington
Frequent Visitor
In response to jackj

‎10-06-2023 06:36 AM

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

Message 4 of 8
241 Views
0

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

View All