measure using VALUE for unique Dates

[ilcaa72]

i am experimenting with DAX, VALUES() creates a table of unqiue values.  if i use UniqueDates = Values(Sales[orderdate]) and drag this on a matrix or table i get the error, "a table of multiple values was suplied where a single value was expected".

i know I used a measure to create this, but i also assumed by 'dont summarize' it would be a Dimension and I could use it as a list of values.

it VALUES() creates a table or column of unique values why do I get an error?  thanks for any help understanding

[Chihiro]

Measure should return single value in context, rather than scalar list.

In measure, VALUES can only be used as intermediate, to supply list to another function.

If you want to create list of unique from dates...

You could create new table in Modeling. And then use Table = VALUES(Table1[Date])

Though since Values will consider Blank as unique, I'd prefer to use DISTINCT (when there are null fields in the column).

[Stachu · Accepted solution]

Measure will always return a scalar value, never a table, VALUES returns a table hence the error
you can use your syntax in a calculated table and it will have the behaviour you expect

EDIT - if you drag Sales[orderdate] to the visual it will only show unique values without any additional code