Is COUNTROWS or COUNT/COUNTA more efficient

[ShivS]

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?

[Greg_Deckler · Accepted solution]

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