https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculated-Column-RANKX-per-Group/m-p/2587240#M74436 <P>HI experts!</P><P>I have a dimensional table that contains an indivudual value column per article:</P><TABLE border="1"><TBODY><TR><TD>Article</TD><TD>Sequence</TD><TD>RANKX</TD></TR><TR><TD>ABC</TD><TD>30</TD><TD>1</TD></TR><TR><TD>ABC</TD><TD>50</TD><TD>3</TD></TR><TR><TD>ABC</TD><TD>80</TD><TD>4</TD></TR><TR><TD>ABC</TD><TD>40</TD><TD>2</TD></TR><TR><TD>CDE</TD><TD>5</TD><TD>1</TD></TR><TR><TD>CDE</TD><TD>8</TD><TD>2</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Now I would like to add a calculated colum that shows me the rank for this column per Article. - as you can see in the last column.</P><P>How is this possible?</P><P>&nbsp;</P> Sun, 19 Jun 2022 10:06:22 GMT joshua1990 2022-06-19T10:06:22Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculated-Column-RANKX-per-Group/m-p/2587240#M74436 <P>HI experts!</P><P>I have a dimensional table that contains an indivudual value column per article:</P><TABLE border="1"><TBODY><TR><TD>Article</TD><TD>Sequence</TD><TD>RANKX</TD></TR><TR><TD>ABC</TD><TD>30</TD><TD>1</TD></TR><TR><TD>ABC</TD><TD>50</TD><TD>3</TD></TR><TR><TD>ABC</TD><TD>80</TD><TD>4</TD></TR><TR><TD>ABC</TD><TD>40</TD><TD>2</TD></TR><TR><TD>CDE</TD><TD>5</TD><TD>1</TD></TR><TR><TD>CDE</TD><TD>8</TD><TD>2</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Now I would like to add a calculated colum that shows me the rank for this column per Article. - as you can see in the last column.</P><P>How is this possible?</P><P>&nbsp;</P> Sun, 19 Jun 2022 10:06:22 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculated-Column-RANKX-per-Group/m-p/2587240#M74436 joshua1990 2022-06-19T10:06:22Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculated-Column-RANKX-per-Group/m-p/2587252#M74437 <P>Hi <a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="92006" data-lia-user-login="joshua1990" class="lia-mention lia-mention-user">joshua1990</a>&nbsp;</P> <P>Add this calculated column to the table:</P> <LI-CODE lang="markup">NewColumn = RANKX(FILTER(Table1, Table1[Article] = EARLIER(Table1[Article])), Table1[Sequence], , ASC)</LI-CODE> <TABLE style="height: 100px; width: 100%; border-collapse: collapse; border-style: groove; border-color: #0c1c49; background-color: #00675f;" border="0" width="100%"> <TBODY> <TR style="height: 15px;"> <TD width="15.961305925030231%" style="width: 92px; height: 15px;"> <P><img /></P> </TD> <TD width="84.03869407496977%" style="width: 485px; height: 15px; text-align: left;"><FONT color="#FFFFFF"><SPAN><STRONG>Please accept the solution when done and consider <FONT color="#FF9900">giving a thumbs up if posts are helpful.</FONT></STRONG></SPAN></FONT><FONT color="#FFFFFF"><SPAN>&nbsp;</SPAN> </FONT><BR /> <P><STRONG><FONT size="4.5" color="#FF99CC">Contact me privately for support with any larger-scale BI needs, tutoring, etc.</FONT></STRONG></P> </TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> Sun, 19 Jun 2022 10:37:28 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculated-Column-RANKX-per-Group/m-p/2587252#M74437 AlB 2022-06-19T10:37:28Z