Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!

Reply
Anonymous
Not 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: 

Capture.PNG

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: 
Donation targets.PNG
And GA data:
GA data.PNG
 
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 1
amitchandak
Super User
Super User

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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

Vote for your favorite vizzies from the Power BI World Championship submissions!

Sticker Challenge 2026 Carousel

Join our Community Sticker Challenge 2026

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

January Power BI Update Carousel

Power BI Monthly Update - January 2026

Check out the January 2026 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.