Can anyone explain why my power bi Dax expression is not working?

[michael_ma]

Hi everyone,

I have this dax expression: 

Exclude = CALCULATE (

    IF (

        MAX ( 'Products'[Product Line] ) = "Keys"

            && [Invoice Gross Amount] = 0,

        TRUE (),

        FALSE ()

    ),

    ALLEXCEPT (

        'Transactions',

        'Transactions'[Document Number]

))

This Dax runs but when I check the table it's not doing what I expected it to be doing. The values are still coming in as False when I'm expecting them to be True. 

[Greg_Deckler]

@michael_ma Why not just:

Exclude = 
    IF (
        MAX ( 'Products'[Product Line] ) = "Keys"
            && [Invoice Gross Amount] = 0,
        TRUE (),
        FALSE ()
    )

[michael_ma]

Hi Greg,

I appreciate replying to me! I need to include the all except because I still want exclude all filter context except for Document Number