Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Calculation between tables

Hi, I have 2 tables, sales and commissions by item for a company I need to sum the commissions by a company please help with DAX SALES Part ID Sales X 20 X 30 X 40 XX 45 ...
Need Help
v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

Hi Anonymous ,

 

Create a measure as below. If it doesn't meet your requirement, kindly share your excepted output to me.

 

Measure = 
VAR k =
    FILTER ( Commissions, Commissions[Part ID] IN VALUES ( SALES[Part ID] ) )
RETURN
    CALCULATE ( SUM ( Commissions[Company Commissions] ), KEEPFILTERS ( k ) )

 

Pbix as attached.

 

Regards,

Frank

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi

thanks, but the commissions its sum of multiplication of sales and commission percent