Forum Discussion

omarpardo5's avatar
omarpardo5
Regular Visitor
2 years ago
Solved

RANKX

Cordial saludo, miembros de la comunidad. Tengo esta situación: He tratado de crear un ranking de clasificación de los programas de formación que tienen la mejor puntuación para un indicador que...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi omarpardo5 ,

     

    From your text description, you want to remove the filter and keep the original results. It is recommended that you try to include the ALL function, which strips out all filters including slicers. If you want to remove the filter but keep the slicer filter, it is recommended that you use the ALLSELECTED function.

                                                                                                                                                             

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

foodd's avatar
foodd
Community Champion
2 years ago

Thank you for starting a conversation in the Power Query Forum. Without your sample Power BI Desktop file, and that your images are not clear (very small), the description leads to believe that you are speaking that there is a TIE. If this is the case, the following Community blog post should help:

 

Breaking Ties in Rankings with RANKX Using Multiple Columns