topic SUMMARIZECOLUMNS with Ignore section in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/SUMMARIZECOLUMNS-with-Ignore-section/m-p/1783055#M37428 <P>Dear Power BI Representative,</P><P>I was reviewing the SUMMARIZECOLUMNS function and in the with Ignore section <A href="https://docs.microsoft.com/en-us/dax/summarizecolumns-function-dax" target="_blank">https://docs.microsoft.com/en-us/dax/summarizecolumns-function-dax</A>&nbsp;it indicated the usage of IGNORE results in the removal of blank values however when I run the query with the IGNORE function it allows for SUMMARIZECOLUMNS to keep the blank values.&nbsp; Is this an error with the guide or an error with DAX studio?&nbsp; Please advise.</P><P>&nbsp;</P><P>Thank you&nbsp;</P> Tue, 13 Apr 2021 19:06:08 GMT lt79_Pax 2021-04-13T19:06:08Z SUMMARIZECOLUMNS with Ignore section https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/SUMMARIZECOLUMNS-with-Ignore-section/m-p/1783055#M37428 <P>Dear Power BI Representative,</P><P>I was reviewing the SUMMARIZECOLUMNS function and in the with Ignore section <A href="https://docs.microsoft.com/en-us/dax/summarizecolumns-function-dax" target="_blank">https://docs.microsoft.com/en-us/dax/summarizecolumns-function-dax</A>&nbsp;it indicated the usage of IGNORE results in the removal of blank values however when I run the query with the IGNORE function it allows for SUMMARIZECOLUMNS to keep the blank values.&nbsp; Is this an error with the guide or an error with DAX studio?&nbsp; Please advise.</P><P>&nbsp;</P><P>Thank you&nbsp;</P> Tue, 13 Apr 2021 19:06:08 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/SUMMARIZECOLUMNS-with-Ignore-section/m-p/1783055#M37428 lt79_Pax 2021-04-13T19:06:08Z Re: SUMMARIZECOLUMNS with Ignore section https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/SUMMARIZECOLUMNS-with-Ignore-section/m-p/1785432#M37503 <P>"<SPAN>Even though both expressions return blank for some rows, they're included since there are no unignored expressions which return blank."</SPAN></P> Wed, 14 Apr 2021 20:20:09 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/SUMMARIZECOLUMNS-with-Ignore-section/m-p/1785432#M37503 lbendlin 2021-04-14T20:20:09Z