Forum Discussion
COUNT , COUNTA DAX Function
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.
Experts, please can you give small variance example.
This is the differnce POWER_TESTING between COUNT and COUNTA
http://community.powerbi.com/t5/Desktop/COUNT-COUNTA-DAX-Function/td-p/217049
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.
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.