Filter by Slicer Selection

Hi jrickerts,

You can try to use the following measure formula if it suitable for your requirement:

Off Promo Qty Sold Pre-Promo =
VAR selectedproduct =
    VALUES ( Products[ProductID] )
VAR currPromotion =
    VALUES ( Promotion[PromotionID] )
RETURN
    CALCULATE (
        SUM ( Sales[Qty Sold] ),
        FILTER (
            ALL ( Sales ),
            'Sales'[ProductID]
                IN selectedproduct
                    && COUNTROWS (
                        FILTER (
                            ALLSELECTED ( Promotion ),
                            [PromotionID]
                                IN currPromotion
                                && 'Sales'[Date] < Promotion[EndDate]
                                && Sales[Date] >= Promotion[StartDate]
                        )
                    ) > 0
        )
    )

Regards,

Xiaoxin Sheng