Forum Discussion
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 se llama Varindice; pero desafortunadamente me clasifica de forma que en algunos casos se repite la puntuación, y cuando aplico filtros sobre el dashboard no toma la clasificación en función de él, sino de forma general. Agradezco su apoyo:
Cuando aplico un filtro, me sale así, cuando debería salir el 1 de primero en la fila y sale es 4:
|
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.
2 Replies
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
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.
