Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Sumproduct formula in PowerBI

Hi All, 

 

I have an excel formula I need to translate in DAX, anyone know how to do it?

 

=SUMPRODUCT(--(ISNUMBER(MATCH(B28:B199999;C28:C49999;0))))

 

Two columns

april

may

 

There can be multiple records for each 

 

(as I continue to tear my hair out!)

 

Thanks All

Need Help

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    HI Anonymous ,

    AFAIK, SUMPRODUCT function will multiplies ranges or arrays together and returns the sum of products. You can consider to use sumx function to get the result:

    Formula =
SUMX ( ALLSELECTED ( Table ), [Column1] * [Column2] )

    Regards,

    Xiaoxin Sheng