Distinct add columns

[samnaw]

Hi 

I want to do this:

SELECT Distinct(column1), column2
FROM table1
WHERE column2 is not null

I know how to do distinct:

FILTER(DISTINCT('DASHBOARD'[CYM_Name]), NOT ISBLANK ( 'DASHBOARD'[CYM_Name]))

I know how to do summarize column:

SUMMARIZE(FILTER('DASHBOARD', NOT ISBLANK ( 'DASHBOARD'[CYM_Name]))
,'DASHBOARD'[SYW],'DASHBOARD'[CYM_Name])

But I want to use DISTINCT instead of summarize. Is that possible? or is summarize the only way you can distinct and then bring another column. 

[v-lionel-msft · Accepted solution]

Hi @samnaw ,

My sample data table.

Column1Column2

A	x1
A	x2
A
B	x3
B	x4
C	x5
D
D

In Database

In Power BI Desktop

If it's not right, please show me the sample data and expected output. 

It should be possible to use the DISTINCT() function, but your [Column2] has no aggregation, which confuses me.

Best regards,
Lionel Chen

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

[amitchandak]

@samnaw , Try like

summarize(filter(Table, not(isblank(Table[column2]))), Table[column1],Table[column2])