Funções DAX: COUNT e COUNTA

[rodrigues_olive]

Atualmente, há uma diferença muito "confuso" entre as funções DAX:COUNT e COUNT. Pois elas, são muito semelhantes quanto ao resultado. Não compreender qual é a utilidade de ambas as semelhanças e, qual das duas medidas é útil? Serei muito grato se alguém puder me ajudar nessa compreensão.

[Anonymous · Accepted solution]

Hi @rodrigues_olive ,

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

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.