Forum Discussion
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 |
| 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 |
2 Replies
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
