cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ephramz
Helper II
Helper II

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.

1 ACCEPTED SOLUTION
v-yanjiang-msft
Community Support
Community Support

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.

vkalyjmsft_0-1637126206008.png

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.

View solution in original post

2 REPLIES 2
v-yanjiang-msft
Community Support
Community Support

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.

vkalyjmsft_0-1637126206008.png

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
Super User
Super User

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.







Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

Proud to be a Super User!




Helpful resources

Announcements
May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors