Measure Net Sales calculated before and after a specific date from other table

Hello kta87 ,

Thank you for your question. You can follow these steps:

1. Create a measure

 Net Sales Before = 
CALCULATE (
    SUM ( SALES[Net Sales] ),
    FILTER (
        ALL ( SALES ),
        'SALES'[Customer ID] = SELECTEDVALUE ( 'Table'[Customer ID] )
            && 'SALES'[Calendar Date] < SELECTEDVALUE ( 'Table'[Event Date] )
    )
)

2. Create another measure

    Net Sales After = 
CALCULATE (
    SUM ( SALES[Net Sales] ),
    FILTER (
        ALL ( SALES ),
        'SALES'[Customer ID] = SELECTEDVALUE ( 'Table'[Customer ID] )
            && 'SALES'[Calendar Date] >= SELECTEDVALUE ( 'Table'[Event Date] )
    )
)

How to Get Your Question Answered Quickly - Microsoft Fabric Community

 If it does not help, please provide more details with your desired out put and pbix file without privacy information.

^{Best Regards,}

^{Yifan Wang}

^{If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.}