Forum Discussion
Is COUNTROWS or COUNT/COUNTA more efficient
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?
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.
1 Reply
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.