Forum Discussion

Yan1981's avatar
Yan1981
Frequent Visitor
3 years ago
Solved

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        
  • parry2k's avatar
    3 years ago

    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! ❤️