CODEWITHSUNDEEP
ssaspowerbidax
genie
genie

Reputation: 305

Dax How to get distinct values from a column

This is the query I'm trying. 

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

Upvotes: 6

Views: 36067

Answers (2)

StelioK
StelioK

Reputation: 1781

This will work:

Evaluate

VALUES('Table'[Column])

Upvotes: 1

Joe G
Joe G

Reputation: 1776

If you are trying to simply create a new, single column table with the distinct values of an existing table, you can use the formula below.

Starting with data like this...

Data

... simply create a new table with this formula to get a list of distinct values.

Locations = DISTINCT(Fruit[Location])

Distinct

Upvotes: 7

Related Questions