How to get distinct or unique value from a table using a measure

[vikrammankar]

Hi,

I have below table 

T

ENAME	SNAME	NOWD
John	Alex	20
John	Alex	20
John	Alex	20

In Microsoft Access when I write query SELECT DISTINCT(NOWD), sname FROM T;

I get below output:

NOWD	SNAME
20	Alex

How do I do the same in Power BI by writing a measure

[Anonymous · Accepted solution]

Hi @vikrammankar ,

I suggest you to create a table visual by "Don't summarize" function in [NOWD] column in Value Field.

My Sample:

Result is as below.

Or you can create a calculated table with distinct (NOWD and SNAME).

Distinct Table = 
SUMMARIZE('Table','Table'[SNAME],'Table'[NOWD])

Result is as below.

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jcalheir]

Hi

In DAX you have the similar function DISTINCT

Please check this microsoft article bellow to see some examples.

https://docs.microsoft.com/pt-pt/dax/distinct-table-function-dax