Forum Discussion

Abhaykumar's avatar
Abhaykumar
Microsoft Employee
10 years ago
Solved

Getting distinct values for multiple columns

Is there a way to get distinct values for multiple columns? Specifically, I want to replicate the following SQL query into PowerBI to create a new table:   SELECT DISTINCT Col1, Col2, Col3 FROM Tab...
  • ankitpatira's avatar
    ankitpatira
    10 years ago

    Abhaykumar You can also select individual columns in query editor and click Remove Duplicates.

     

  • achinm45's avatar
    achinm45
    10 years ago

    Hi Abhaykumar,

     

    Use DAX and in DAX the function SUMMARIZE().

    Summarize will pull out distinct values from columns.

     

    So your resultset will be new table from Summarize

    Table_Output =  Summarize(Table_IN,Col1,Col2,Col3)

     

    I hope it helps !

     

    BR,

    Achin

achinm45's avatar
achinm45
Advocate IV
10 years ago

Hi Abhaykumar,

 

Use DAX and in DAX the function SUMMARIZE().

Summarize will pull out distinct values from columns.

 

So your resultset will be new table from Summarize

Table_Output =  Summarize(Table_IN,Col1,Col2,Col3)

 

I hope it helps !

 

BR,

Achin

GiveMeArrays's avatar
GiveMeArrays
Frequent Visitor
4 years ago

Hi achinm45,

 

Receiving the following error when using your suggested function (below; names anonymized):

"The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value."

 

SUMMARIZE(table,[col1],[col2],[col3])
 
Thank You!
  • mwinds's avatar
    mwinds
    Helper I
    3 years ago

    I'm getting the same thing. Did you find a solution?