Forum Discussion

POWER_TESTING's avatar
POWER_TESTING
Icon for Helper I rankHelper I
8 years ago
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...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    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.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

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...