HOW TO DO IN POWER BI THE SUMPRODUCT

[Syndicate_Admin]

Hello good morning, who could help me with this consultation

I have two columas

%Margin and % Participation and I need to make the average of the two, in excel they are done with the sumproduct function, attached example.

=sumaproducto(B2:B4; A2:A4)

In PBI how could I do it?

Thank you

[smpa01 · Accepted solution]

@Syndicate_Admin 

Measure1 = SUMX('Table','Table'[Column1]*'Table'[Column2]) --showing sumproduct by each row
Measure2 = calculate(SUMX('Table','Table'[Column1]*'Table'[Column2]),ALL('Table')) --showing subtotal of sumproduct in each row