Forum Discussion

1234567666's avatar
1234567666
Regular Visitor
3 years ago
Solved

Add Total Average Column within Matrix

Hi, I would like to add an Average Column at the end of this table. Could someone please help? The rows are 1and2, column is New_Month and Value is Acctamt. Some of the months do not have values fo...
  • devanshi's avatar
    devanshi
    3 years ago

    AverageColumn =
    IF( HASONEVALUE('Table'[New_Month]),
                  IF( 'Table'[New_Month] IN {"1", "2"}, DIVIDE( SUM('Table'[Acctamt]),                                                                                         COUNTROWS(FILTER('Table', 'Table'[New_Month] IN {"1", "2"})) ),
                       BLANK() ),
    BLANK() )

devanshi's avatar
devanshi
Icon for Helper V rankHelper V
3 years ago

AverageColumn =
IF( HASONEVALUE('Table'[New_Month]),
              IF( 'Table'[New_Month] IN {"1", "2"}, DIVIDE( SUM('Table'[Acctamt]),                                                                                         COUNTROWS(FILTER('Table', 'Table'[New_Month] IN {"1", "2"})) ),
                   BLANK() ),
BLANK() )