Hi, I have one promotion product table, and one Fact table. I need to calculate the Basket sales of the orders that contain the promotion products (not the product sales). For example, if one order contains promotion product A (sales of $20) and non-promotion product ($50), the total basket sales for this order is $70.
Could you please help me to understand how to calculate the basket sales of orders that contain promotion products?
MikeOrder_Total.pbix (236.7 KB)