Distinct () function in Power BI
It is a Table Manipulation function that returns a table or manipulates existing tables. Measures are used in some of the most common data analyses.
Go to New measures, and switch to Table tools from there.
Example 1:
The DAX DISTINCT returns a one-column table that contains the distinct values from the specified column. In other words, duplicate values are removed, and only unique values are returned.
Syntax: DISTINCT (<column name>)
Output:
Below the table created to which the distinct query needs to be applied, it is the one-column table that contains the distinct values from the specified column or table expression.
Example 1:
The distinct query for the alphabet datatype.
Formula: DISTINCT('SLS Order Details_Client Master'[Client Name])
Output:
Example 2:
The distinct query for the number data type column.
Formula: DISTINCT('SLS Order Detials_Master'[Product Unit])
Output:
Example 3:
The distinct query for the date datatype column.
Formula: DISTINCT('SLS Order Detials_Master'[Order Date (dd-mm-yyyy)])
Output:
Power BI – Distinct() function
Data Analysis Expressions (DAX) include many functions that return a table rather than a value. The table isn’t displayed but is used to provide input to other functions. For example, you can retrieve a table and then count the distinct values in it or calculate dynamic sums across filtered tables or columns.
Dataset used:
The given data set contains information on the library supplies sold by a library manufacturer to different clients. All the relevant details like client name, client state name, product unit, etc. can be seen in it.
Dataset Link: SLS Order Details_Client Master