CALCULATE(VALUES(column name))

uaTaG87 — Wed, 10 May 2023 22:03:09 GMT

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 command does. I am working on a decently big project and part of the code was previously made by an expert. I have a measure in this project that needs to calculate some costs. However, my issue is understanding what the command "CALCULATE(VALUES(*Table name[column name]*) returns.

In particular, it is inside a SUMX and the code is this:

SUMX(
*Table name 1*,
[*a measure that returns an integer*]*
CALCULATE( VALUES (*Table name[column name]*))
)

Thank you very much for answering.

Re: CALCULATE(VALUES(column name))

FreemanZ — Wed, 10 May 2023 22:17:18 GMT

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.

topic CALCULATE(VALUES(*column name*)) in DAX Commands and Tips

CALCULATE(VALUES(*column name*))

Re: CALCULATE(VALUES(*column name*))

topic CALCULATE(VALUES(column name)) in DAX Commands and Tips

CALCULATE(VALUES(column name))

Re: CALCULATE(VALUES(column name))