Forum Discussion

sean_cochran's avatar
sean_cochran
Icon for Resolver I rankResolver I
2 years ago
Solved

Unable to reference LINESTX table output using SELECTCOLUMN

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 i...
Need Help
  • DataInsights's avatar
    DataInsights
    2 years ago

    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.

     

     

DataInsights's avatar
DataInsights
Icon for Super User rankSuper User
2 years ago

sean_cochran,

 

Try adding the name of the new column:

 

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

 

  • sean_cochran's avatar
    sean_cochran
    Icon for Resolver I rankResolver I
    2 years ago

    Same result:

     

    • DataInsights's avatar
      DataInsights
      Icon for Super User rankSuper User
      2 years ago

      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's avatar
        sean_cochran
        Icon for Resolver I rankResolver I
        2 years ago

        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?