Forum Discussion
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 type of Column values with Count, how it is different from CountA?
has microsoft made some changes to language ?
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-
1 Reply
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-