https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/ALL-with-Table-vs-ALL-with-Column/m-p/1135540#M16917 <P>I have a question related to how ALL works when I pass in the Table vs when I pass in the Column. I understand it removes any filter applied to table or column. I noticed that If I use it with COUNTX and pass the column (COUNTX(ALL(columnA)), columnA) it would count only the distinct values (why?), and when I pass the table (COUNTX(ALL(tableA)), columnA) it would count all values. Is this behavior by design?</P><P>I do not understand how this relates to removing the filters.</P><P>TIA</P> Tue, 02 Jun 2020 09:26:24 GMT Anonymous 2020-06-02T09:26:24Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/ALL-with-Table-vs-ALL-with-Column/m-p/1135540#M16917 <P>I have a question related to how ALL works when I pass in the Table vs when I pass in the Column. I understand it removes any filter applied to table or column. I noticed that If I use it with COUNTX and pass the column (COUNTX(ALL(columnA)), columnA) it would count only the distinct values (why?), and when I pass the table (COUNTX(ALL(tableA)), columnA) it would count all values. Is this behavior by design?</P><P>I do not understand how this relates to removing the filters.</P><P>TIA</P> Tue, 02 Jun 2020 09:26:24 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/ALL-with-Table-vs-ALL-with-Column/m-p/1135540#M16917 Anonymous 2020-06-02T09:26:24Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/ALL-with-Table-vs-ALL-with-Column/m-p/1135548#M16919 <P>A column reference always does a group by aggregation.&nbsp;</P><P>Kind regards,</P><P>Steve.&nbsp;</P> Tue, 02 Jun 2020 09:26:24 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/ALL-with-Table-vs-ALL-with-Column/m-p/1135548#M16919 stevedep 2020-06-02T09:26:24Z