Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
@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?
User | Count |
---|---|
101 | |
90 | |
79 | |
70 | |
70 |
User | Count |
---|---|
112 | |
96 | |
96 | |
75 | |
72 |