topic Rank within category and month in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Rank-within-category-and-month/m-p/2858436#M91954 <TABLE><TBODY><TR><TD>Date</TD><TD>Name</TD><TD>Amount</TD></TR><TR><TD>1/19/2022</TD><TD>A</TD><TD>80</TD></TR><TR><TD>1/15/2022</TD><TD>A</TD><TD>100</TD></TR><TR><TD>1/14/2022</TD><TD>B</TD><TD>60</TD></TR><TR><TD>2/14/2022</TD><TD>C</TD><TD>20</TD></TR><TR><TD>2/7/2022</TD><TD>C</TD><TD>40</TD></TR><TR><TD>2/11/2022</TD><TD>A</TD><TD>50</TD></TR><TR><TD>3/14/2022</TD><TD>B</TD><TD>30</TD></TR><TR><TD>3/18/2022</TD><TD>A</TD><TD>20</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P><P><BR />&nbsp;In the above sample data, i need to create a pbi report, which shows the ranking of each categories in each month.</P><P>So&nbsp; for Month 2 , will show for Category A,Rank =&nbsp;2, Category C , Rank=1.</P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>For month = 1, Rank for Category A = 1, Category B =2</P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Mon, 24 Oct 2022 07:51:22 GMT Anonymous 2022-10-24T07:51:22Z Rank within category and month https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Rank-within-category-and-month/m-p/2858436#M91954 <TABLE><TBODY><TR><TD>Date</TD><TD>Name</TD><TD>Amount</TD></TR><TR><TD>1/19/2022</TD><TD>A</TD><TD>80</TD></TR><TR><TD>1/15/2022</TD><TD>A</TD><TD>100</TD></TR><TR><TD>1/14/2022</TD><TD>B</TD><TD>60</TD></TR><TR><TD>2/14/2022</TD><TD>C</TD><TD>20</TD></TR><TR><TD>2/7/2022</TD><TD>C</TD><TD>40</TD></TR><TR><TD>2/11/2022</TD><TD>A</TD><TD>50</TD></TR><TR><TD>3/14/2022</TD><TD>B</TD><TD>30</TD></TR><TR><TD>3/18/2022</TD><TD>A</TD><TD>20</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P><P><BR />&nbsp;In the above sample data, i need to create a pbi report, which shows the ranking of each categories in each month.</P><P>So&nbsp; for Month 2 , will show for Category A,Rank =&nbsp;2, Category C , Rank=1.</P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>For month = 1, Rank for Category A = 1, Category B =2</P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Mon, 24 Oct 2022 07:51:22 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Rank-within-category-and-month/m-p/2858436#M91954 Anonymous 2022-10-24T07:51:22Z Re: Rank within category and month https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Rank-within-category-and-month/m-p/2858477#M91956 <P>Hi,</P> <P>Please check the below picture and the attahced pbix file.</P> <P>&nbsp;</P> <P><img /></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Mon, 24 Oct 2022 08:03:25 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Rank-within-category-and-month/m-p/2858477#M91956 Jihwan_Kim 2022-10-24T08:03:25Z Re: Rank within category and month https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Rank-within-category-and-month/m-p/2858523#M91958 <P>hello lease use:</P><LI-CODE lang="markup">Ranking = RANKX( ALLSELECTED( Ranking[Name] ) , CALCULATE( SUM( Ranking[Amount]) ))</LI-CODE><P>&nbsp;</P><P><img /></P><P><img /></P><P> </P><P><img /></P><P>  </P> Mon, 24 Oct 2022 08:16:42 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Rank-within-category-and-month/m-p/2858523#M91958 Anonymous 2022-10-24T08:16:42Z Re: Rank within category and month https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Rank-within-category-and-month/m-p/2858872#M91981 <P>Is there any way to improve the performance of the above formula?</P> Mon, 24 Oct 2022 10:18:39 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Rank-within-category-and-month/m-p/2858872#M91981 Anonymous 2022-10-24T10:18:39Z