Problem with syntax in ADDCOLUMNS with CALCULATE

[Pbiuserr]

Hello, 
I have a measure

VAR _table =

ADDCOLUMNS (

SUMMARIZE ( FctTable, FctTable[Gender], Fcttable[Category] ),

"@HC", [Percentage change headcount vLY]

)

and I struggle to make that table be only for Category = 1. Tried to insert here calculate but keep getting syntax errors. Is there a possibility to filter it out?

[Jihwan_Kim · Accepted solution]

Hi,

please try the below.

VAR _table =
FILTER (
    ADDCOLUMNS (
        SUMMARIZE ( FctTable, FctTable[Gender], Fcttable[Category] ),
        "@HC", [Percentage change headcount vLY]
    ),
    Fcttable[Category] = 1
)

[Pbiuserr]

Thank you! works good
Can you perhaps help me how to retrive name with biggest [Percentage Change Headcount vLY] ?