COUNT , COUNTA DAX Function

[POWER_TESTING]

Hi Experts,

Please can anyone give example for COUNT VS COUNTA

Table:

DATA

1

5

9

TRUE

FALSE

7

COUNT (i have read in blog only numbers but giving 6 count) and COUNTA also giving same result..

Please what is the different.

Thanks in Advance..!!!

[Greg_Deckler]

Hmm, did some testing with this, even on columns that only contained dates and both returned the same count. So, the documentation doesn't seem to mesh up with reality...

[POWER_TESTING]

Experts, please can you give small variance example.

[miltenburger]

This is the differnce @POWER_TESTING between COUNT and COUNTA

http://community.powerbi.com/t5/Desktop/COUNT-COUNTA-DAX-Function/td-p/217049

[POWER_TESTING]

Thanks for reply,

Which you had shared that link having one statement...

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

in my data also have TRUE/FALSE and null data aswell.... 

COUNT taking everything, it's not throwing any error.

My question....

COUNT, COUNTA, COUNTX, COUNTAX these all functions showing same result... 

Note:  that link perfectly working in Excel speread sheet, but not in POWER BI. i'm really confusing. 

[v-chuncz-msft · Accepted solution]

@POWER_TESTING,

Despite the same name of statistical functions, the difference in the way they are used in DAX and Excel exists because in DAX a column has a type, and its type determines the behavior of aggregation functions. Excel handles a different data type for each cell, whereas DAX handles a single data type for each column. DAX deals with data in tabular form with well-defined types for each column, whereas Excel formulas work on heterogeneous cell values, without well-defined types.