Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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.
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.
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.
Proud to be a Super User!
User | Count |
---|---|
90 | |
74 | |
67 | |
63 | |
55 |
User | Count |
---|---|
101 | |
92 | |
74 | |
60 | |
59 |