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

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