VALUES giving me error for any field

Hi there, is there any video where VALUES function is covered in-depth? I’m having this error message all the time (still a newbie) and not sure how can I get this sorted.

Big thanks

image

@SamSPAIN,

Here you go:

The reason you’re getting this error is that a measure can only return a scalar (i.e., single value), while the VALUES function returns a table. Thus, VALUES is most often used as a filter condition statement or as a table parameter within another function (explained in detail the video above).

Helpful tip: Dax.guide is an awesome online resource that tells you what type of function it is, whether it returns a scalar or a table, whether it’s an iterator, and lots of other valuable information. When trying to decrypt some of the obtuse error messages that Power BI spits out, it’s invaluable.

Hope this is helpful.

  • Brian

Remember you can search for any video from Enterprise DNA within the forum. Just go to the search area and click the ENTERPRISE DNA ONLINE button

Sam