Forum Discussion
Need help with measure VALUES
Proposed Time = IF([Proposed Time] > 0, [Proposed Time], IF(VALUES('Table2'[Time(mins)])>0,VALUES('Table2'[Time(mins]),IF('Table2'[Allocated Time]>0,'Table2'[Allocated Time],BLANK())))
I have a measure as per above
'Table2'[Time(mins)] is a column value in Table2.
However, if i use VALUES('Table2'[Time(mins)]) in the measure, it significantly slows down the processing speed of the report.
How can I work around this/ how do i convert the column to a measure instead so i dont have to use the DAX function 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.
2 Replies
Can you please share some sample data and desired output to get a better understanding of the problem. and if possible if you can share the data model screenshot.
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.
