SUMX vs Calculate Filter

[RobertSlattery]

Can someone please help me to understand why this doesn't work...

Order Book = 
CALCULATE(
    CALCULATE(
        SUMX(orders, IF([Status] = 60, [Value])),
        FILTER(
            Orders,
            [Status] = 60
            && [Inv Date] >= MAX('Dim Date'[Date Key])
            || [Status] <> 60
        )
    ),
    Filter(
        ALLSELECTED('Dim Date'),
        'Dim Date'[Date] < MAX('Dim Date'[Date])
        && MAX('Dim Date'[Date]) < TODAY()
    )
)

Or this...

Order Book 2 = 
CALCULATE(
    [Order Intake],
    FILTER(
        Orders,
        [Status] = 60
        && [Inv Date] >= MAX('Dim Date'[Date Key])
        || [Status] <> 60
    ),
    Filter(
    ALLSELECTED('Dim Date'),
    'Dim Date'[Date] < MAX('Dim Date'[Date])
    && MAX('Dim Date'[Date]) < TODAY()
    )
)

And this does...

Order Book 3 = 
CALCULATE( 
    SUMX(Orders, 
        IF(
            [Status] = 60
            && [Inv Date] >= MAX('Dim Date'[Date])
            || [Status] <> 60,
            [Order Intake]
        )
    ),
    Filter(
        ALLSELECTED('Dim Date'),
        'Dim Date'[Date] < MAX('Dim Date'[Date])
        && MAX('Dim Date'[Date]) < TODAY()
    )
)

example uploaded here

[Anonymous]

HI @RobertSlattery,

Maybe you can try to use below measure formula:

Order Book 2 = 
CALCULATE (
    SUM ( Orders[Value] ),
    FILTER (
        ALLSELECTED ( Orders ),
        [Status] = 60
            && [Inv Date] >= MAX ( 'Dim Date'[Date Key] )
            || [Status] <> 60
    ),
    FILTER (
        ALLSELECTED ( 'Dim Date' ),
        'Dim Date'[Date] < MAX ( 'Dim Date'[Date] )
            && MAX ( 'Dim Date'[Date] ) < TODAY ()
    )
)

If above not help, please explain your requirement more clearly with some expected result to help us clarify your scenario.

Regards,

Xiaoxin Sheng