Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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..!!!
Solved! Go to Solution.
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...
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |