Forum Discussion
rankx
Buenas! quisiera rankear cual de mis locales tuvo mas venta pero no logro hacerlo con la funcion rankx. Que estoy haciendo mal?
Gracias de antemano
Yan1981 try this
Rank = RANKX ( ALL ( YourTable[Local] ), CALCULATE ( SUM ( YourTable[Venta REMA] ) ), , DESC )👉 Learn Power BI and Fabric - subscribe to our YT channel - @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! ❤️
4 Replies
Yan1981 try this
Rank = RANKX ( ALL ( YourTable[Local] ), CALCULATE ( SUM ( YourTable[Venta REMA] ) ), , DESC )👉 Learn Power BI and Fabric - subscribe to our YT channel - @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! ❤️
it worked! Thanks for your time ❤️
Yan1981 try this measure:
Rank = RANKX ( ALL ( YourTable ), CALCULATE ( SUM ( YourTable[Venta REMA] ) ), , DESC )👉 Learn Power BI and Fabric - subscribe to our YT channel - @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! ❤️
😞 no funciono..
