Ranking Card

[Br1bn]

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! 

[amitchandak]

@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

[Br1bn]

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?