SUMAPRODUCTO EN POWER BI

[Syndicate_Admin]

That such a team good afternoon, I wanted to consult you something since you are kingpins on this power bi issue. you will see I am currently working on a project and I need to know if there are any formulas that are similar to SUMAPRODUCTO of excel.. multiply and sume at the same time..

[v-rzhou-msft · Accepted solution]

Hi @Syndicate_Admin 

In your formula, I find volumn in Table A and %Overweight in Table C.

I think you formula in Excel is as below.

=SUMPRODUCT(B3:B6,(G3:G6/100+1))

In Power BI add Index column in Power Query in your tables. Power BI need index column as a key word to filter which row product with which row in differencet tables.

Measure:

Sumproduct = 
SUMX(SUMMARIZE('Table A','Table A'[Volumn],"Product",SUM('Table A'[Volumn])*(DIVIDE(SUM('Table C'[%overweight]),100)+1)),[Product])

Result is as below.

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[amitchandak]

@Syndicate_Admin , depending on need sumx and productx should help

https://docs.microsoft.com/en-us/dax/productx-function-dax

https://docs.microsoft.com/en-us/dax/sumx-function-dax

sumx(Table, Table[A] * Table[B])

ProductX(Table, Table[A])

ProductX(Table, Table[A] + Table[B])

[Syndicate_Admin]

Could you make this formula with Sumx xq probe and I didn't get it?

Table A for me is volume, B is %reba, C is % Overweight

SUMPRODUCT(volume/((%Overweight/100)+1)