Forum Discussion

Alusine_Kamara's avatar
Alusine_Kamara
Icon for Helper II rankHelper 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 ...
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!

miTutorials's avatar
miTutorials
Icon for Super User rankSuper 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!

  • Alusine_Kamara's avatar
    Alusine_Kamara
    Icon for Helper II rankHelper II
    2 years ago

    Thank you miTutorials. Concise!!!