Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Syntax error

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's avatar
    Anonymous
    4 years ago

    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's avatar
tamerj1
Community Champion
4 years ago

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