Forum Discussion

lastnn30's avatar
lastnn30
Post 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/

     

     

1 Reply

  • VahidDM's avatar
    VahidDM
    Super 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/