This is the query I'm trying. EVALUATE SELECTCOLUMNS('MyTable',"col1",DISTINCT(VALUES('MyTable'[Email])))