Forum Discussion

ERing's avatar
ERing
Post Partisan
1 year ago
Solved

Is there any technical or practical difference between these two measures?

I have data structured like below and I need to return the number of records from my table that meet the following conditions: 1. 'Table_A'[Has_APP_Recording] = "Y" 2. 'Table_A'[Training_Comple...
Need Help
  • danextian's avatar
    danextian
    1 year ago

    Hi ERing 

     

    The first one is faster as it simply counts the rows. The second one iterates row by row before evaluating and counting non-blank values in a specific column (Count_Job_Id). This extra step introduces additional overhead, especially if the column is a calculated column or if the dataset is large. Therefore, COUNTROWS is generally more efficient when you only need to count the number of rows that meet certain conditions, while COUNTX should be used when you're specifically interested in counting valid (non-blank) entries of a particular column within that filtered set.

maruthisp's avatar
maruthisp
Super User
1 year ago

Hi ERing ,

As per my knowledge, below is the differences which I can see:

If you want to count every matching record, even those with no Job ID or where Count_Job_Id is empty, go with Valid_Jobs_1.

If you only want to count records that also carry a valid Job ID (or any non-blank column), then Valid_Jobs_2 is the right choice.

Please let me know if you have further questions.

If this reply helped solve your problem, please consider clicking "Accept as Solution" so others can benefit too. And if you found it useful, a quick "Kudos" is always appreciated, thanks! 

 

Best Regards, 

Maruthi 

LinkedIn - http://www.linkedin.com/in/maruthi-siva-prasad/ 

X            -  Maruthi Siva Prasad - (@MaruthiSP) / X