Syntax error

[Anonymous]

Does anyone know what this error means? 

I'm trying to create a measure that will count the rows in a column for either active or planned.

Thank you,

Sam

[Anonymous · Accepted solution]

Hi @Anonymous ,

Try this.

ActiveFTE =
CALCULATE (
    COUNTROWS ( '2022 Headcount Forecast-CountSA' ),
    '2022 Headcount Forecast-CountSA'[Dec21 Status Active/Planned/Forecast] = "Active"
)

Here are some references that may be helpful.

DAX syntax

COUNTROWS function

Best Regards,
Community Support Team_Gao

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[tamerj1]

hi @Anonymous 
Watch out the table name. When it contains spaces you should write like this
'2022 Headcount Forcast-CountSA'