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

2 Replies

  • 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'

  • Anonymous's avatar
    Anonymous
    Not applicable
    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