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 Ra...
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?