Forum Discussion
MichaelHutchens
Helper V
Helper VError in DAX summary table with filters
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 =
...
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"))
syasmin25Helper V
Helper VHi 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"
)
)
MichaelHutchensThank you, that's perfect!