Create a new table with DAX from an existing table

[PbiCeo]

Hello everyone,

I want to create a new table with DAX from an existing table according to a specific condition like below SQL:

select distinct col1 ,col2, col3 from Table1 where col1 > 150 

 Please tell me how to wirte DAX syntax for that?

Thanks in advance,

Vladi

[amitchandak]

@PbiCeo ,

You can try like

summarize(filter(table,table[col1] > 150),table[col1] ,table[col2], table[col3])

in case of visual, you can put three columns on visual and put a visual level filter col1>150

[Greg_Deckler]

@PbiCeo - Try:

New Table =
DISTINCT(
  SELECTCOLUMNS(
    FILTER('Table',[col1] > 150),
    "col1",[col1],
    "col2",[col2],
    "col3",[col3]
  )
)