Need help with measure VALUES

[ephramz]

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.

[v-yanjiang-msft · Accepted solution]

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 _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[FarhanAhmed]

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.