Forum Discussion
Solved
COUNT , COUNTA DAX Function
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 r...
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.
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...