https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/HELP-WITH-RANKING/m-p/2213637#M52307 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="342236" data-lia-user-login="aileenc07" class="lia-mention lia-mention-user">aileenc07</a> , In power bi rank happen against some column only&nbsp; </P> <P>&nbsp;</P> <P>like</P> <P>rankx(allselected(Table[Column]), [Measure])</P> <P>&nbsp;</P> <P>For Rank Refer these links<BR /><A href="https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures" target="_blank">https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures</A><BR /><A href="https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns" target="_blank">https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns</A><BR /><BR /></P> <P>Rank Tie breaker <BR /><A href="https://community.powerbi.com/t5/Community-Blog/Breaking-Ties-in-Rankings-with-RANKX-Using-Multiple-Columns/ba-p/918655" target="_blank">https://community.powerbi.com/t5/Community-Blog/Breaking-Ties-in-Rankings-with-RANKX-Using-Multiple-Columns/ba-p/918655</A><BR /><A href="https://databear.com/how-to-use-the-dax-rankx-function-in-power-bi/" target="_blank">https://databear.com/how-to-use-the-dax-rankx-function-in-power-bi/</A></P> <P>&nbsp;</P> <P>&nbsp;</P> Tue, 30 Nov 2021 09:43:49 GMT amitchandak 2021-11-30T09:43:49Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/HELP-WITH-RANKING/m-p/2213622#M52305 <P>Hello, I'm totally a newbie and I've tried to research and watch youtube but nothing seems to be working for me.</P><P>It's a ranking problem, sorry. I just want a seperate column that ranks the Total Output % column, 1-29.</P><P><img /></P><P>&nbsp;</P><P>Thank you <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Tue, 30 Nov 2021 09:36:38 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/HELP-WITH-RANKING/m-p/2213622#M52305 aileenc07 2021-11-30T09:36:38Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/HELP-WITH-RANKING/m-p/2213637#M52307 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="342236" data-lia-user-login="aileenc07" class="lia-mention lia-mention-user">aileenc07</a> , In power bi rank happen against some column only&nbsp; </P> <P>&nbsp;</P> <P>like</P> <P>rankx(allselected(Table[Column]), [Measure])</P> <P>&nbsp;</P> <P>For Rank Refer these links<BR /><A href="https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures" target="_blank">https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures</A><BR /><A href="https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns" target="_blank">https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns</A><BR /><BR /></P> <P>Rank Tie breaker <BR /><A href="https://community.powerbi.com/t5/Community-Blog/Breaking-Ties-in-Rankings-with-RANKX-Using-Multiple-Columns/ba-p/918655" target="_blank">https://community.powerbi.com/t5/Community-Blog/Breaking-Ties-in-Rankings-with-RANKX-Using-Multiple-Columns/ba-p/918655</A><BR /><A href="https://databear.com/how-to-use-the-dax-rankx-function-in-power-bi/" target="_blank">https://databear.com/how-to-use-the-dax-rankx-function-in-power-bi/</A></P> <P>&nbsp;</P> <P>&nbsp;</P> Tue, 30 Nov 2021 09:43:49 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/HELP-WITH-RANKING/m-p/2213637#M52307 amitchandak 2021-11-30T09:43:49Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/HELP-WITH-RANKING/m-p/2213794#M52311 <P>Hello, thank you so much for responding</P><P><img /></P><P>this is the error if try it</P><P>please help</P><P>&nbsp;</P><P>thanks</P> Tue, 30 Nov 2021 10:40:00 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/HELP-WITH-RANKING/m-p/2213794#M52311 aileenc07 2021-11-30T10:40:00Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/HELP-WITH-RANKING/m-p/2213927#M52321 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="342236" data-lia-user-login="aileenc07" class="lia-mention lia-mention-user">aileenc07</a> , Close allselected after the full name </P> <P>&nbsp;</P> <P>rankx(allselected(Table[Full Name]<STRONG>)</STRONG>, [Total Output %])</P> Tue, 30 Nov 2021 11:50:34 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/HELP-WITH-RANKING/m-p/2213927#M52321 amitchandak 2021-11-30T11:50:34Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/HELP-WITH-RANKING/m-p/2213945#M52324 <P>THANK YOU SO MUCH!! IT WORKED</P> Tue, 30 Nov 2021 12:01:39 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/HELP-WITH-RANKING/m-p/2213945#M52324 aileenc07 2021-11-30T12:01:39Z