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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
Anonymous
Not applicable

DAX Measure - SUM sales by part number and multiply by commission rate from related table

I have two data sources and I'm trying to write a Measure that will SUM the Sales Amount column and multiply it by the Commission% of the related table. I spent an hour searching for examples of this but I haven't been able to find anything so far. Apologies if this has been solved already.

 

dpiech10_0-1643055713247.png

 

 

1 ACCEPTED SOLUTION
AlexisOlson
Super User
Super User

Do your tables have a relationship on [Part]?

 

If so, then you should be able to write something like this:

SUMX ( Sales, Sales[Sales Amount] * RELATED ( CommisionRates[Commission%] ) )

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

They have a relationship on a column I added in PowerQuery that's [Cust] & [Part] concatenated.

 

Your suggestion worked brilliantly. Thank you so much.

AlexisOlson
Super User
Super User

Do your tables have a relationship on [Part]?

 

If so, then you should be able to write something like this:

SUMX ( Sales, Sales[Sales Amount] * RELATED ( CommisionRates[Commission%] ) )

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.