Forum Discussion
ilcaa72
Helper IV
Helper IVmeasure using VALUE for unique Dates
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 value...
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
Chihiro
Solution Sage
Solution Sage
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).