Table Functions

[Alusine_Kamara]

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.

[miTutorials · Accepted solution]

• 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]

Thank you miTutorials. Concise!!!