Solved : What is the equivalent of SUMPRODUCT (EXCEL) to PowerBI for my Multiple measures

[JWick1969]

Hi 
I have a matrix table with 5 columns and 4 of them are measures. Could not figure out on how to convert the below formula(excel) with sumproduct into PowerBI. below are the expected output for sumproduct column. Any ideas how could i achieve this? thanks in advance.

Thank you.

[v-yangliu-msft · Accepted solution]

Hi  @JWick1969 ,

Here are the steps you can follow：

1. Create calculated column.

sumproduct =
DIVIDE(
    'Table'[w/o] * 'Table'[wo/volume] + 'Table'[with] * 'Table'[with volume], 'Table'[wo/volume] + 'Table'[with volume])

2. Result:

Best Regards,

Liu Yang

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

[JWick1969]

Thank you very much. It's already working using the actual data.

[JWick1969]

Thank you for the reply. I try this solution to actual data.