https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/doubts-understanding-RANKX-when-used-for-a-calculated-column/m-p/3552169#M136675 <P>assume a need to create calculated column in table Customer<BR />we want a ranking of sales among customers belonging to a single country, in "a universe" of different countries; so we have a ranking made for different countries<BR />the formulae edited is=<BR />RANKX ( ALLEXCEPT (Customer, Customer[Country]), [measure sales] )<BR />i am conscious there is an outer row context (automaticaly created just because we are creating a calc colum) and an inner row context (inside RankX; for building a virtual table of lookup values with the second argument: [measure sales] )....<BR />can anybody please clearly explain what is the ALLEXCEPT function doing?<BR />is it eliminating filter context for all the table except the Country?<BR />or is it creating a table virtual witll all columns of table Customer except the column of Country?<BR />how does the inner row context works? how does the outer row context works?<BR />i have read and heard different opinions about AllExcept performance. Some people say that it is NOT creating a table (but it is eliminating filter sensitivity in all columns except the Country),<BR />while others have stated that it does create a virtual table that does not have the (key field, i might add) Country column<BR />if the latter is correct, for the vida of me ....i cannot fathom how is it possible for the RANKX to work...when the key field of Country is not present inside the virtual table<BR />thanks to all and anyone who would like to share wonderful knowledge about these doubts o'mine<BR />hope everyone is happy and safe. Best regards in advance</P> Sat, 25 Nov 2023 19:02:18 GMT becha77 2023-11-25T19:02:18Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/doubts-understanding-RANKX-when-used-for-a-calculated-column/m-p/3552169#M136675 <P>assume a need to create calculated column in table Customer<BR />we want a ranking of sales among customers belonging to a single country, in "a universe" of different countries; so we have a ranking made for different countries<BR />the formulae edited is=<BR />RANKX ( ALLEXCEPT (Customer, Customer[Country]), [measure sales] )<BR />i am conscious there is an outer row context (automaticaly created just because we are creating a calc colum) and an inner row context (inside RankX; for building a virtual table of lookup values with the second argument: [measure sales] )....<BR />can anybody please clearly explain what is the ALLEXCEPT function doing?<BR />is it eliminating filter context for all the table except the Country?<BR />or is it creating a table virtual witll all columns of table Customer except the column of Country?<BR />how does the inner row context works? how does the outer row context works?<BR />i have read and heard different opinions about AllExcept performance. Some people say that it is NOT creating a table (but it is eliminating filter sensitivity in all columns except the Country),<BR />while others have stated that it does create a virtual table that does not have the (key field, i might add) Country column<BR />if the latter is correct, for the vida of me ....i cannot fathom how is it possible for the RANKX to work...when the key field of Country is not present inside the virtual table<BR />thanks to all and anyone who would like to share wonderful knowledge about these doubts o'mine<BR />hope everyone is happy and safe. Best regards in advance</P> Sat, 25 Nov 2023 19:02:18 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/doubts-understanding-RANKX-when-used-for-a-calculated-column/m-p/3552169#M136675 becha77 2023-11-25T19:02:18Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/doubts-understanding-RANKX-when-used-for-a-calculated-column/m-p/3552206#M136678 <P><EM><STRONG><A href="https://dax.guide/allexcept/" target="_blank" rel="noopener">https://dax.guide/allexcept/</A></STRONG></EM></P> <LI-CODE lang="markup">When used as a table function, ALLEXCEPT materializes all the unique combinations of the columns in the table specified in the first argument that are not listed in the following arguments.</LI-CODE> Sat, 25 Nov 2023 20:59:01 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/doubts-understanding-RANKX-when-used-for-a-calculated-column/m-p/3552206#M136678 ThxAlot 2023-11-25T20:59:01Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/doubts-understanding-RANKX-when-used-for-a-calculated-column/m-p/3563595#M137372 <P>Could anyone else please try to reply the specific inquiry?<BR />i found the original reply helpful but shortcoming<BR />thanks anyone, and i dont mean to sound pedantic or grateful. Happy last month of 2k23</P> Fri, 01 Dec 2023 18:26:20 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/doubts-understanding-RANKX-when-used-for-a-calculated-column/m-p/3563595#M137372 becha77 2023-12-01T18:26:20Z