How to calculate the order total containing certain products

DAX DAX Calculations
1

Hi, Guys, I have one table for sales and one table for products. I need to calculate the total sales of the orders that contain the products on the product table. How I can do that using DAX?

Thanks as always!

MikeOrder_Total.pbix (233.2 KB)

2

Hi @Mike,

See if this is helpful.

image
image369×707 14.6 KB

Order_Total.pbix (203.2 KB)

3

Hi @Mike

Please see below DAX if it serves the purpose.

Total Sales = 
CALCULATE ( 
    SUMX (
        Sales, 
        Sales[Sales Amount]
    ), 
    FILTER(
        Sales, 
        RELATED( SKU[SKU]  )
    )
)
4

Hi @Mike, did the response provided by the contributors help you solve your query? If not, how far did you get, and what kind of help you need further? If yes, kindly mark the thread as solved. Thanks!

5

@MK3010 @Melissa sorry for late reply, I was stuck with something else in past few days. I will check the formula and let you know if I have any quesiton.

Thanks again for all your help!

Mike