Forum Discussion
Helper IINeed help with measure VALUES
Hi ephramz ,
According to your description, I create a sample, Proposed Time is a column in table, while Time(mins) in another table, the two tables have relationship. When you use VALUES function, if the sample has more results meet the criteria, an error will occurred,because VALUES function returns a column, you can try to use MAX function to return the current value, but if measure have multiple results you will get only max result by Max function.
Here's the VALUES function you can refer.
https://docs.microsoft.com/en-us/dax/values-function-daxVALUES function (DAX) - DAX | Microsoft Docs
If it still not work, please provide me with more details about your sample.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community SupportHi ephramz ,
According to your description, I create a sample, Proposed Time is a column in table, while Time(mins) in another table, the two tables have relationship. When you use VALUES function, if the sample has more results meet the criteria, an error will occurred,because VALUES function returns a column, you can try to use MAX function to return the current value, but if measure have multiple results you will get only max result by Max function.
Here's the VALUES function you can refer.
https://docs.microsoft.com/en-us/dax/values-function-daxVALUES function (DAX) - DAX | Microsoft Docs
If it still not work, please provide me with more details about your sample.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.