DAX Problem-2

 Problem:

I need to create a measure where i need to sum the uploads based on combi common in both the tables

Solution

SUMX(
    FILTER(
        'Receipts SAP',
        'Receipts SAP'[VendorPartcombi] IN VALUES('Feature Wise Sampling'[vendorpartcombi])
    ),
    'Receipts SAP'[RCTQTY]
)

Expected_uploads = 
[Receipt_SAP] * SUM('Feature Wise Sampling'[Sampling])

Explanation:

• [Receipt_SAP]: This refers to the measure you created earlier.
• SUM('Feature Wise Sampling'[Sampling]): This sums the Sampling column from the Feature Wise Sampling table.