cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

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 ?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: COUNT , COUNTA DAX Function

 

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
Highlighted
Community Support
Community Support

Re: COUNT , COUNTA DAX Function

 

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Solution Authors
Top Kudoed Authors