topic Re: Syntax error in DAX Commands and Tips

Syntax error

Anonymous — Fri, 25 Mar 2022 23:50:13 GMT

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

Re: Syntax error

tamerj1 — Sat, 26 Mar 2022 03:16:29 GMT

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

Re: Syntax error

Anonymous — Tue, 29 Mar 2022 02:31:32 GMT

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