table variable

[jshumaker]

I am trying to use the output of a LINESTX function in a DAX formula.  When I try to access the Slope1 value from a table variable, the field is not found.  Although if I create a calculated table using LINESTX, I am able to access the Slope1 value.

2 attempts at measure calling linestx variable both w/ error

calculated table definition w/out error

measure calling table w/out error

[bcdobbs · Accepted solution]

You just need:

SELECTCOLUMNS( linVar, [Slope1] )

It works referencing the variable but the intellisense can't pick it up at the moment. Just ignore the red underline.