Error in DAX summary table with filters

[MichaelHutchens]

Hi everyone, I'm hoping this is relatively simple - I'm getting the error below when creating a summary table in DAX - might someone know what I'm doing wrong?

Here's my code:

Table3 = 
    SUMMARIZE (
    'Employee',
	'Employee'[Employee Name],
	'Employee'[Email Address],
	'Employee'[Employee ID],
	'Employee'[Employee Status],
	'Employee'[Current Employee Email Record]
    )
    FILTER (
        'Employee',
        'Employee'[Current Employee Email Record] = "Y"
		&& NOT ( 'Employee'[Employee Status] ) IN { "Withdrawn" }
    )
)

[syasmin25 · Accepted solution]

Hi Michael, 

Please try this out, 

 SUMMARIZECOLUMNS(

    'Employee'[Employee Name],

    'Employee'[Email Address],

    'Employee'[Employee ID],

    'Employee'[Employee Status],

    'Employee'[Current Employee Email Record],

    FILTER (

        'Employee',

        'Employee'[Current Employee Email Record] = "Y"

        && 'Employee'[Employee Status] <> "Withdrawn" 

    )

)

[MichaelHutchens]

Thank you, that's perfect!