https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Add-Total-Average-Column-within-Matrix/m-p/3297650#M122898 <P><SPAN>AverageColumn =<BR />IF( HASONEVALUE('Table'[New_Month]),<BR />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF( 'Table'[New_Month] IN {"1", "2"}, DIVIDE( SUM('Table'[Acctamt]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;COUNTROWS(FILTER('Table', 'Table'[New_Month] IN {"1", "2"})) ),<BR />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;BLANK() ),<BR />BLANK() )</SPAN></P> Thu, 22 Jun 2023 11:36:00 GMT devanshi 2023-06-22T11:36:00Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Add-Total-Average-Column-within-Matrix/m-p/3294408#M122689 <P>Hi, I would like to add an Average Column at the end of this table. Could someone please help?</P><P>The rows are 1and2, column is New_Month and Value is Acctamt.</P><P>Some of the months do not have values for instance total average of the first row below should be -677.39(Total) / 3(number of month that have values)</P><P><img /></P><P> </P> Wed, 21 Jun 2023 03:05:10 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Add-Total-Average-Column-within-Matrix/m-p/3294408#M122689 1234567666 2023-06-21T03:05:10Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Add-Total-Average-Column-within-Matrix/m-p/3297650#M122898 <P><SPAN>AverageColumn =<BR />IF( HASONEVALUE('Table'[New_Month]),<BR />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF( 'Table'[New_Month] IN {"1", "2"}, DIVIDE( SUM('Table'[Acctamt]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;COUNTROWS(FILTER('Table', 'Table'[New_Month] IN {"1", "2"})) ),<BR />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;BLANK() ),<BR />BLANK() )</SPAN></P> Thu, 22 Jun 2023 11:36:00 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Add-Total-Average-Column-within-Matrix/m-p/3297650#M122898 devanshi 2023-06-22T11:36:00Z