Forum Discussion

NavinTyagi's avatar
NavinTyagi
New Member
9 years ago
Solved

COUNT , COUNTA DAX Function

Did anyone noticed with Count Function we can very well count even Date,Text Documentation at one place says it count only number, other place mention about Text and Date too I am able to Count any...
Data Modeling
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

     

    Hi NavinTyagi,

     

    This is a recent enhancement to the COUNT function. Previously COUNT function doesn't count strings but just raise an error. We have since enhanced the function to count strings as well. You can refer to Remarks section in this article: COUNT Function (DAX).

     

    The COUNT function counts rows that contain the following kinds of values:

    • Numbers

    • Dates

    • Strings

     

    Regarding the COUNTA Function (DAX), it counts not just rows that contain numeric values, but also rows that contain nonblank values, including text, dates, and logical values.

     

    The difference between those two functions are, COUNTA can count TRUE/FALSE column but COUNT still raises an error.

     

    Best Regards,
    Qiuyun Yu

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

 

Hi NavinTyagi,

 

This is a recent enhancement to the COUNT function. Previously COUNT function doesn't count strings but just raise an error. We have since enhanced the function to count strings as well. You can refer to Remarks section in this article: COUNT Function (DAX).

 

The COUNT function counts rows that contain the following kinds of values:

  • Numbers

  • Dates

  • Strings

 

Regarding the COUNTA Function (DAX), it counts not just rows that contain numeric values, but also rows that contain nonblank values, including text, dates, and logical values.

 

The difference between those two functions are, COUNTA can count TRUE/FALSE column but COUNT still raises an error.

 

Best Regards,
Qiuyun Yu