Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

SUMPRODUCT Measure Using Fields from Same Table

I'm trying to create a Measure that calculates the SUMPRODUCT using fields from the same table.   Using an EXCEL layout as seen below, the formula used to calculate the ".024%" in D1 is:  =SUMPRODUC...
Need Help
Tips and Tricks
  • DataNinja777's avatar
    DataNinja777
    2 years ago

    Hi Anonymous ,

    In that case, I suppose you don't need to include that 'Term' column in your sumproduct calculation either, and when that is removed, Power BI sumx calculation result and sumproduct calculation results are the same, although I would write dax formula in the following manner which is simpler.  

    Best regards,

     

DataNinja777's avatar
DataNinja777
Super User
2 years ago

Hi Anonymous 

In your Excel formula, term is also included, but I would have throught that the overall rate calculation should be based on the amount and the rates only. I'd appreciate it if you could let me know why the indexing column of "Term" should also be included in the calculation.  

Best regards,

Anonymous's avatar
Anonymous
Not applicable
2 years ago

DataNinja777  I'm not sure actually, that's just the exact formula that is being used in the Excel calculation but if it's not necessary to get to the correct answer then I suppose it's not applicable.