topic Dynamic Ranking in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dynamic-Ranking/m-p/1703196#M35071 <P>Hi,&nbsp; I have the below scenario where I want to calculate rank of the materials based on the <STRONG>Date, ID and Item</STRONG> in ascending order.</P><P>And Each time a slicer filter is selected, the rank must change dynamically within the selection.&nbsp;</P><P>&nbsp;</P><P>Before Filter :</P><TABLE><TBODY><TR><TD>Material</TD><TD>&nbsp; ID</TD><TD>Item</TD><TD>Date</TD><TD>Quantity&nbsp;&nbsp;</TD><TD>Rank</TD></TR><TR><TD>Mobile</TD><TD>103</TD><TD>1</TD><TD>01/01/2021</TD><TD>&nbsp; &nbsp; 2</TD><TD>1</TD></TR><TR><TD>Mobile</TD><TD>103</TD><TD>2</TD><TD>01/01/2021</TD><TD>&nbsp; &nbsp;16</TD><TD>2</TD></TR><TR><TD>Mobile</TD><TD>104</TD><TD>6</TD><TD>05/01/2021</TD><TD>&nbsp; &nbsp; 8</TD><TD>3</TD></TR><TR><TD>TV</TD><TD>100</TD><TD>1</TD><TD>01/01/2021</TD><TD>&nbsp; &nbsp;10</TD><TD>1</TD></TR><TR><TD>TV</TD><TD>101</TD><TD>3</TD><TD>12/01/2021</TD><TD>&nbsp; &nbsp; 5</TD><TD>2</TD></TR><TR><TD>TV</TD><TD>102</TD><TD>6</TD><TD>16/01/2021</TD><TD>&nbsp; &nbsp;15</TD><TD>3</TD></TR></TBODY></TABLE><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV><P>After Date Selection between 10/01/2021 to 20/01/2021 :</P><TABLE><TBODY><TR><TD>Material</TD><TD>&nbsp; ID</TD><TD>Item</TD><TD>Date</TD><TD>Quantity&nbsp; &nbsp;&nbsp;</TD><TD>Rank</TD></TR><TR><TD>TV</TD><TD>101</TD><TD>3</TD><TD>12/01/2021</TD><TD>&nbsp; &nbsp; &nbsp;5</TD><TD>1</TD></TR><TR><TD>TV</TD><TD>102</TD><TD>6</TD><TD>16/01/2021</TD><TD>&nbsp; &nbsp; &nbsp;15</TD><TD>2</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Any help would be appreciated. Thanks in advance.</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Thu, 04 Mar 2021 11:36:37 GMT AishwaryaS 2021-03-04T11:36:37Z Dynamic Ranking https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dynamic-Ranking/m-p/1703196#M35071 <P>Hi,&nbsp; I have the below scenario where I want to calculate rank of the materials based on the <STRONG>Date, ID and Item</STRONG> in ascending order.</P><P>And Each time a slicer filter is selected, the rank must change dynamically within the selection.&nbsp;</P><P>&nbsp;</P><P>Before Filter :</P><TABLE><TBODY><TR><TD>Material</TD><TD>&nbsp; ID</TD><TD>Item</TD><TD>Date</TD><TD>Quantity&nbsp;&nbsp;</TD><TD>Rank</TD></TR><TR><TD>Mobile</TD><TD>103</TD><TD>1</TD><TD>01/01/2021</TD><TD>&nbsp; &nbsp; 2</TD><TD>1</TD></TR><TR><TD>Mobile</TD><TD>103</TD><TD>2</TD><TD>01/01/2021</TD><TD>&nbsp; &nbsp;16</TD><TD>2</TD></TR><TR><TD>Mobile</TD><TD>104</TD><TD>6</TD><TD>05/01/2021</TD><TD>&nbsp; &nbsp; 8</TD><TD>3</TD></TR><TR><TD>TV</TD><TD>100</TD><TD>1</TD><TD>01/01/2021</TD><TD>&nbsp; &nbsp;10</TD><TD>1</TD></TR><TR><TD>TV</TD><TD>101</TD><TD>3</TD><TD>12/01/2021</TD><TD>&nbsp; &nbsp; 5</TD><TD>2</TD></TR><TR><TD>TV</TD><TD>102</TD><TD>6</TD><TD>16/01/2021</TD><TD>&nbsp; &nbsp;15</TD><TD>3</TD></TR></TBODY></TABLE><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV><P>After Date Selection between 10/01/2021 to 20/01/2021 :</P><TABLE><TBODY><TR><TD>Material</TD><TD>&nbsp; ID</TD><TD>Item</TD><TD>Date</TD><TD>Quantity&nbsp; &nbsp;&nbsp;</TD><TD>Rank</TD></TR><TR><TD>TV</TD><TD>101</TD><TD>3</TD><TD>12/01/2021</TD><TD>&nbsp; &nbsp; &nbsp;5</TD><TD>1</TD></TR><TR><TD>TV</TD><TD>102</TD><TD>6</TD><TD>16/01/2021</TD><TD>&nbsp; &nbsp; &nbsp;15</TD><TD>2</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Any help would be appreciated. Thanks in advance.</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Thu, 04 Mar 2021 11:36:37 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dynamic-Ranking/m-p/1703196#M35071 AishwaryaS 2021-03-04T11:36:37Z Re: Dynamic Ranking https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dynamic-Ranking/m-p/1703505#M35080 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="288113" data-lia-user-login="AishwaryaS" class="lia-mention lia-mention-user">AishwaryaS</a> , Try a measure like</P> <P>&nbsp;</P> <P>calculate(Count(Table[Quantity]), filter(allselected(Table), Table[Material] = max(Table[Material]) &amp;&amp; Table[Date] &lt;= max(Table[Date])))</P> Thu, 04 Mar 2021 14:36:02 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dynamic-Ranking/m-p/1703505#M35080 amitchandak 2021-03-04T14:36:02Z