Measure with sum and a multiply

[mrstillchicken]

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)

How can I do that?

[harshnathani · Accepted solution]

Hi @mrstillchicken ,

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)

[mrstillchicken]

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