DAX Sum Column based on condition in 2 other tables

[wktan]

I'm trying to calculate the Sales Order Qty of items that fall under defined campaigns. However, the information is scattered across a few related tables as shown in the image below. What DAX formula should I use to calculate the total Sales Order Qty within campaign periods using the data from different tables?

 

[Anonymous]

Hi @wktan ,

It's better to share some sample data because you data model looks quite complicate.

Best Regards,

Jay

[community_pinki]

Hey @wktan  ,

Please try using this measure :-

Sales Order Quantity = CALCULATE
(
SUM(SalesOrderLines[OrderSalesQuantity]),
DATESBETWEEN(SalesOrderHeadersV2[OrderCreationDateTime],
MIN(Campaigns[StartDate]),
MAX(Campaigns[EndDate])
))

[wktan]

Thanks @community_pinki for the suggestion.
I have tried using this measure and added it to a matrix visual (with all the campaigns listed on rows) but it shows the following error.