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,
I have a ticket table for which I am using COUNTROWS(tableName) to get the total tickets. I would like to understand if COUNTA(ticketColumnName) is more efficient as I need to further use it in other measures?
Solved! Go to Solution.
@Anonymous Testing this on a million row dataset, I found no statistical difference in the DAX query for either of these. Total display time (DAX query, Visual display, Other) teneded to favor COUNTROWS by about 30 milliseconds but that wasn't always the case and could have been a variety of factors.
@Anonymous Testing this on a million row dataset, I found no statistical difference in the DAX query for either of these. Total display time (DAX query, Visual display, Other) teneded to favor COUNTROWS by about 30 milliseconds but that wasn't always the case and could have been a variety of factors.
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 |
---|---|
109 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |