Forum Discussion
Anonymous
5 years agoNot applicable
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
Best,
Raphaelle
1 Reply
- amitchandak
Super User
Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.