Forum Discussion

ilcaa72's avatar
ilcaa72
Helper IV
7 years ago
Solved

measure 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...
Need Help
  • Stachu's avatar
    Stachu
    7 years ago

    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

Stachu's avatar
Stachu
Community Champion
7 years ago

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