In DAX how do I RETURN the sum of a calculated column from a DAX Table Variable created via ADDCOLUMN

Question

How do I RETURN the value of this table variable column?

Answer 1

You can access column variables of previously defined table variables by SUMX function:

Measure = 
var DaxTable = ADDCOLUMNS(...)

var result = 
CALCULATE(
    SUMX( DaxTable , [amount])
)
return
    result