Forum Discussion

POWER_TESTING's avatar
POWER_TESTING
Helper 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 result..

Please what is the different.

 

Thanks in Advance..!!!

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.

5 Replies

      • POWER_TESTING's avatar
        POWER_TESTING
        Helper I
        8 years ago

        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. 

         

         

         

         

  • Greg_Deckler's avatar
    Greg_Deckler
    Community 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...