topic Re: Filtering the Report defaults RANKX and it just show just 1 in DAX Commands and Tips

topic Re: Filtering the Report defaults RANKX and it just show just 1 in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Filtering-the-Report-defaults-RANKX-and-it-just-show-just-1/m-p/3348214#M125722 <P>thank you so much! worked perfectly! </P> Tue, 25 Jul 2023 07:48:35 GMT roshenrrujj 2023-07-25T07:48:35Z Filtering the Report defaults RANKX and it just show just 1 https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Filtering-the-Report-defaults-RANKX-and-it-just-show-just-1/m-p/3335853#M125098 <P>Hi all, is there a way to make RANKX to show the right rank in overall data even after filters applied? </P><P> </P><P>this is my data sample. </P><P> </P><TABLE><TBODY><TR><TD>Job</TD><TD>Contractor</TD><TD>Contractor Payment</TD><TD>State</TD><TD>Region</TD><TD>Town</TD><TD>Work Started</TD><TD>Work Ended</TD></TR><TR><TD>8439750</TD><TD>1086</TD><TD>$10,329.26</TD><TD>QLD</TD><TD>QLD Rural</TD><TD>Rockhampton</TD><TD>14/03/2023</TD><TD> </TD></TR><TR><TD>8441239</TD><TD>1126</TD><TD>$82,135.70</TD><TD>QLD</TD><TD>QLD Rural</TD><TD>Rockhampton</TD><TD>1/03/2023</TD><TD> </TD></TR><TR><TD>9909507</TD><TD>1148</TD><TD>$4,020.85</TD><TD>NSW</TD><TD>NSW Rural</TD><TD>Tweed Heads</TD><TD>3/05/2023</TD><TD> </TD></TR><TR><TD>8438720</TD><TD>1198</TD><TD>$4,042.37</TD><TD>QLD</TD><TD>QLD Rural</TD><TD>Rockhampton</TD><TD>3/02/2023</TD><TD>30/03/2023</TD></TR><TR><TD>8438720</TD><TD>1198</TD><TD>$10,501.92</TD><TD>QLD</TD><TD>QLD Rural</TD><TD>Rockhampton</TD><TD>3/02/2023</TD><TD>30/03/2023</TD></TR><TR><TD>8439750</TD><TD>1198</TD><TD>$24,447.44</TD><TD>QLD</TD><TD>QLD Rural</TD><TD>Rockhampton</TD><TD>12/04/2023</TD><TD> </TD></TR><TR><TD>8450245</TD><TD>1198</TD><TD>$199,771.46</TD><TD>NSW</TD><TD>NSW Rural</TD><TD>Tweed Heads</TD><TD>6/04/2023</TD><TD> </TD></TR><TR><TD>8450432</TD><TD>1305</TD><TD>$43,029.86</TD><TD>TAS</TD><TD>TAS</TD><TD>Hobart</TD><TD>24/05/2023</TD><TD> </TD></TR><TR><TD>8444572</TD><TD>1484</TD><TD>$253,608.70</TD><TD>QLD</TD><TD>QLD Rural</TD><TD>Rockhampton</TD><TD>16/02/2023</TD><TD> </TD></TR><TR><TD>9906018</TD><TD>1649</TD><TD>$8,329.19</TD><TD>VIC</TD><TD>VIC Metro</TD><TD>Melbourne</TD><TD>8/03/2023</TD><TD>23/05/2023</TD></TR><TR><TD>8454213</TD><TD>1655</TD><TD>$75,492.70</TD><TD>VIC</TD><TD>VIC Rural</TD><TD>Albury/Wodonga</TD><TD>1/05/2023</TD><TD> </TD></TR><TR><TD>60101349</TD><TD>1743</TD><TD>$913.68</TD><TD>VIC</TD><TD>VIC Metro</TD><TD>Melbourne</TD><TD>12/01/2023</TD><TD>12/01/2023</TD></TR><TR><TD>8452116</TD><TD>1824</TD><TD>$15,431.13</TD><TD>SA</TD><TD>SA</TD><TD>Adelaide</TD><TD>12/05/2023</TD><TD> </TD></TR><TR><TD>8452263</TD><TD>1824</TD><TD>$23,402.84</TD><TD>WA</TD><TD>WA</TD><TD>Perth</TD><TD>5/05/2023</TD><TD> </TD></TR><TR><TD>8442947</TD><TD>1832</TD><TD>$169,773.98</TD><TD>VIC</TD><TD>VIC Metro</TD><TD>Melbourne</TD><TD>25/01/2023</TD><TD> </TD></TR><TR><TD>8453700</TD><TD>1832</TD><TD>$118,862.25</TD><TD>VIC</TD><TD>VIC Rural</TD><TD>Bendigo</TD><TD>27/02/2023</TD><TD> </TD></TR><TR><TD>8445412</TD><TD>1869</TD><TD>$79,651.77</TD><TD>QLD</TD><TD>QLD Rural</TD><TD>Rockhampton</TD><TD>6/04/2023</TD><TD> </TD></TR><TR><TD>9908698</TD><TD>1918</TD><TD>$2,904.14</TD><TD>QLD</TD><TD>QLD Metro</TD><TD>Brisbane</TD><TD>28/02/2023</TD><TD> </TD></TR><TR><TD>9908698</TD><TD>1918</TD><TD>$1,920.60</TD><TD>QLD</TD><TD>QLD Metro</TD><TD>Brisbane</TD><TD>28/02/2023</TD><TD> </TD></TR></TBODY></TABLE><P> </P><P> </P><P>my RANKX:</P><DIV><DIV><SPAN>RANK = </SPAN><SPAN>RANKX</SPAN><SPAN>(</SPAN><SPAN>ALLSELECTED</SPAN><SPAN>(</SPAN><SPAN>DATA</SPAN><SPAN>[Contractor]</SPAN><SPAN>), </SPAN><SPAN>[Avg Payment]</SPAN><SPAN>)</SPAN></DIV><DIV> </DIV><DIV><SPAN><SPAN>result:<BR /></SPAN></SPAN><img /><P> </P><P>but when i filter the table, lets say to contractor=1824, instead of 8, i get 1</P><img /><P><BR />can someone please help me to come up with a DAX query that would produce the original RANK even after the filtering applied? <BR /><BR />thanks. <SPAN> </SPAN></P></DIV></DIV><P> </P> Tue, 18 Jul 2023 07:49:35 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Filtering-the-Report-defaults-RANKX-and-it-just-show-just-1/m-p/3335853#M125098 roshenrrujj 2023-07-18T07:49:35Z Re: Filtering the Report defaults RANKX and it just show just 1 https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Filtering-the-Report-defaults-RANKX-and-it-just-show-just-1/m-p/3336062#M125109 <P>Instead of ALLSELECTED you need to use ALL</P> <LI-CODE lang="markup">My Rank = RANKX( ALL('Table'[Contractor]), [Avg Payment] )</LI-CODE> Tue, 18 Jul 2023 09:19:23 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Filtering-the-Report-defaults-RANKX-and-it-just-show-just-1/m-p/3336062#M125109 johnt75 2023-07-18T09:19:23Z Re: Filtering the Report defaults RANKX and it just show just 1 https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Filtering-the-Report-defaults-RANKX-and-it-just-show-just-1/m-p/3348214#M125722 <P>thank you so much! worked perfectly! </P> Tue, 25 Jul 2023 07:48:35 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Filtering-the-Report-defaults-RANKX-and-it-just-show-just-1/m-p/3348214#M125722 roshenrrujj 2023-07-25T07:48:35Z