Forum Discussion

lastnn30's avatar
lastnn30
Icon for Post Patron rankPost Patron
4 years ago
Solved

Count Rows vs Count Distinct Rows

Hi In Power Query --> Group by --> Operator: there are 2 options Count Rows and Count Distinct Rows. What is the difference? I tried them both and I got the same result. Thank you very much. ...
Need Help
  • VahidDM's avatar
    VahidDM
    4 years ago

    Hi lastnn30 

     

    You get the same result because you data table has Distinct rows.

    If you add a duplicate/same row to the table then the result will be different.

     

    In General, Count Rows will count all rows disregarding the Distinct rows (values), but Count Distinct Rows will count the same rows as 1 row.

     

    If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
    Appreciate your Kudos!!
    LinkedIn:     www.linkedin.com/in/vahid-dm/

     

     

VahidDM's avatar
VahidDM
Icon for Super User rankSuper User
4 years ago

Hi lastnn30 

 

You get the same result because you data table has Distinct rows.

If you add a duplicate/same row to the table then the result will be different.

 

In General, Count Rows will count all rows disregarding the Distinct rows (values), but Count Distinct Rows will count the same rows as 1 row.

 

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/