Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Multiply 2 columns by rows accors 2 tables

Hi everyone, 

 

I am trying to track the success of a donation campaign.

 

I have a data 3 set with 3 tables: 

I need to have a measure (or column) telling me how much money has been given away. 
I created this measure: 

         Amount given = SUM('Donation targets'[SEK amount per signup])*SUM('GA data'[Login & Signup])
 
Knowing that I have a different amount of donation depending on the project, the measure above works fine as long as I split it by project. 
This issue is when I want to see the total. With the measure I created, it 1st sums up all the "amount per signup" then sums up all the "logins" and then multiply (which is normal with such a formula, I agree).
 
Here is what 'Donation targets' looks like: 
And GA data:
 
Can you help me find a way to have 'Donation targets'[SEK amount per signup])*('GA data'[Login & Signup]) on a row basis so it takes into account the project?

Best,
Raphaelle

1 Reply

  • Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.