Count function BUG!!

[armanfalah]

Hi

COUNT Function has been described in many blogs and books as a function that counts numeric values, but I tried it on a nonnumeric value and it counts all the nonnumeric values!! so what is the difference between Count and CountA?

https://msdn.microsoft.com/en-us/query-bi/dax/countx-function-dax?f=255&MSPPError=-2147217396

Thanks,

Arman

[Anonymous]

@armanfalah,

The duocument about Count function is misleading. Please check Product Team's response.

"The documentation is misleading, we'll update the document. COUNT function will count the values in a pure string column. The function only skips string values in the case of a DAX expression that returns variant data type. When COUNT function is used on top of a variant data type, it only counts the numeric and datetime values but skips boolean and text values."

Regards,
Lydia