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

kta87  can you try this

before = CALCULATE(SUM(Sales[Net Sales]), FILTER(All(Sales),Sales[Customer ID]=MAX(Event[Customer ID])&&Sales[Date]<=MAX(Event[Date])))

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.}