Unable to reference LINESTX table output using SELECTCOLUMN

[sean_cochran]

UPDATE: sample file here. Look at the DAX Query View. I'm developing a calculation item, but using the DAX Query View for testing purposes.

I have stored the output of a LINESTX function (which is a table) in a variable:

// Calculate regression line based on measureTable
VAR line = LINESTX( measureTable, [Y], [X], TRUE)

This outputs a table of values as expected:

However, when I try to extract specific values from that table using "SELECTCOLUMNS", the columns [Slope1] and [Intercept] are not recognized:

Does anyone have any idea what I might be doing wrong?

[DataInsights]

@sean_cochran,

Try adding the name of the new column:

VAR slope = SELECTCOLUMNS ( line, "Slope1", [Slope1] )

[sean_cochran]

Same result:

[DataInsights · Accepted solution]

@sean_cochran,

It appears there is a bug in the DAX editor. When I view the calculation item in Tabular Editor, it doesn't contain an error. See if you can use the calculation item successfully.

[sean_cochran]

The calculation item worked. I'm very surprised - normally I'm the one at fault. Is there an official process to report bugs like this?

[DataInsights]

@sean_cochran,

Glad to hear it works. You can report the issue at the link below:

https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues