Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Measure with sum and a multiply

Hi,   I want to sum a column and have that multiplyed by another column.  Example: Revenue Amount 100 2 50 5   So it needs to be 100*2 and 50*5 and have that summarized (450) Ho...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous ,

     

     

    SUMAB = SUMX('Table','Table'[Amount]*'Table'[Revenue])
     
     

    Regards,
    Harsh Nathani

    Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

 

 

SUMAB = SUMX('Table','Table'[Amount]*'Table'[Revenue])
 
 

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Anonymous Thanks! I was trying this, no I see what I did wrong!