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        
Need Help
  • parry2k's avatar
    parry2k
    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! ❤️

parry2k's avatar
parry2k
Super User
3 years ago

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

  • Yan1981's avatar
    Yan1981
    Frequent Visitor
    3 years ago

    😞 no funciono..