Forum Discussion

uaTaG87's avatar
uaTaG87
New Member
3 years ago

CALCULATE(VALUES(*column name*))

Hi everyone, I am not very expert in DAX language, but I can program. However, I don't find really straight forward some mechanics of the language. I am struggling to try to understand what this co...
FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

hi uaTaG87 

A one row one column table can be used as single value in DAX. So your code makes sense only when VALUES() returns a single value, as CALCULATE expects a expression returning a single value. Otherwise, it prompts error.