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 ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

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