Forum Discussion

Alusine_Kamara's avatar
Alusine_Kamara
Helper II
2 years ago
Solved

Table Functions

Good morning from my side in West Africa.  Please can I ask if someone can help me with the difference (s), between the following Table functions:
1.   DISTINCT
2.   DISTINCTCOUNT
3.   COUNTROWS

Thanks in advance.

Need Help
  • miTutorials's avatar
    miTutorials
    2 years ago
    • The DISTINCT() function,  returns one column table that contains unique values.
    • The COUNTROWS() function,  is used to count the number of rows in a table.
    • The DISTINCTCOUNT() function in Power BI is aggregation function used to count the number of distinct or Unique values in a column or an expression. 

     

     

    Best regards,

    Ismail | MiTutorials

    MiTutorials on YouTube

    Explore over 200+ Power BI tutorials and enhance your skills!

2 Replies

  • miTutorials's avatar
    miTutorials
    Super User
    2 years ago
    • The DISTINCT() function,  returns one column table that contains unique values.
    • The COUNTROWS() function,  is used to count the number of rows in a table.
    • The DISTINCTCOUNT() function in Power BI is aggregation function used to count the number of distinct or Unique values in a column or an expression. 

     

     

    Best regards,

    Ismail | MiTutorials

    MiTutorials on YouTube

    Explore over 200+ Power BI tutorials and enhance your skills!