Calculation between tables

[Anonymous]

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
XX	50
XXX	45
XXX	40
XXX	21

Commissions
Part ID	Company Commissions	Company ID
X	25%	AA
X	35%	BB
X	40%	CC
XX	25%	BB
XX	75%	CC
XXX	30%	AA
XXX	30%	BB
XXX	40%	CC
y	100%	AA
YY	50%	BB
YY	50%	AA

[v-frfei-msft]

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]

Hi

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