Forum Discussion
Ranking Card
Hi, I got a database of transactions with (to simplify) two columns: PRODUCT/ REVENUE
I want to create a ranking of products based on REVENUE, so I created a new measure like
Rank By Revenue = RANKX(ALL(Data[Product]), Data[Revenue],,DESC)
and it is working properly, the problem is that I want to create a CARD which is showing just the position of a specific product (fixed).
My idea was to:
- create a card with using the measure
- applying a filter at visual level to report the rank of that specific product
Unfortunately it is not working, any ideas?
Thanks in advance!
2 Replies
Br1bn , you should create a measure rank
Rank By Revenue = RANKX(ALL(Data[Product]), calculate(Sum(Data[Revenue])),,DESC)
Measure Rank: https://www.youtube.com/watch?v=DZb_6j6WuZ0&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=40
You can also think of the index function
Power BI Index function: Top/Bottom Performer by name and value- https://youtu.be/HPhzzCwe10U
Thanks for your feedback, anyway the calculation is not working problem probably because I'm applying the ranking on that filtered by year, is it possible to add the dimension year (another dimension of the database) to the calculation?
