How to make a sum aggregate by group ? Equivalent of sumifs on Power BI ?

rico_o_o — Sat, 20 May 2023 14:24:57 GMT

Hello,

My table is called "Sales".

Each invoice is divided into different invoice lines. I would like to add a column with a formula that would enable me to aggregate the amounts of the invoice lines according to the invoice number to which they are attached.

Example: this new column would display for the first two lines the amount 5 because 2+3+6 = 11 = total amount of invoice A.

Can you help me please ? Thank you so much!

Re: How to make a sum aggregate by group ? Equivalent of sumifs on Power BI ?

FreemanZ — Sat, 20 May 2023 10:25:05 GMT

hi rico_o_o

are you expecting a calculated column like below:

column = SUMX( FILTER( sales, sales[Invoice_number]=EARLIER(sales[Invoice_number]) ), sales[Amount(in euro)] )

topic Re: How to make a sum aggregate by group ? Equivalent of sumifs on Power BI ? in DAX Commands and Tips

How to make a sum aggregate by group ? Equivalent of sumifs on Power BI ?

Re: How to make a sum aggregate by group ? Equivalent of sumifs on Power BI ?