Forum Discussion

kd3975_odi's avatar
kd3975_odi
New Member
9 years ago
Solved

Subtotal Table on multiple columns based on 1 primary column

Hi,   I am new to Power BI and I am trying to subtotal a number of columns based on 1 primary column.   The table structure is as follows with the primary column being the ContractID and the subt...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi kd3975_odi,

     

    You can directly drag these columns to matrix to show the summary result or use SUMMARIZE function to get the summary table.

     

     

    Table formula:

    Table = SUMMARIZE(Sheet10,Sheet10[ContractID ],"Total ActInvoiceValue",SUM(Sheet10[ActInvoiceValue ]),"Total EstInvoiceValue",SUM(Sheet10[EstInvoiceValue ]),"Total InvoiceBalance",SUM(Sheet10[InvoiceBalance ]))

     

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi kd3975_odi,

 

You can directly drag these columns to matrix to show the summary result or use SUMMARIZE function to get the summary table.

 

 

Table formula:

Table = SUMMARIZE(Sheet10,Sheet10[ContractID ],"Total ActInvoiceValue",SUM(Sheet10[ActInvoiceValue ]),"Total EstInvoiceValue",SUM(Sheet10[EstInvoiceValue ]),"Total InvoiceBalance",SUM(Sheet10[InvoiceBalance ]))

 

 

Regards,

Xiaoxin Sheng