Dax How to get distinct values from a column

Viewed 22044

This is the query I'm trying.

EVALUATE
SELECTCOLUMNS('MyTable',"col1",DISTINCT(VALUES('MyTable'[Email])))
2 Answers

This will work:

Evaluate

VALUES('Table'[Column])
Related