Forum Discussion

saud968's avatar
saud968
Memorable Member
1 year ago

Dax Studio Error

Hi  I am getting the below error as per the screenshot  Actual error  Correlation Id: 45e64fd5-8acd-738e-e54d-c8610e9ec64d Error Details: Failed to get the column type at index 0 from th...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
saud968's avatar
saud968
Memorable Member
1 year ago

I know $SYSTEM.TMSCHEMA_MEASURES gets the measures and that's what I want to do. 

I get below error when I use SELECT ID FROM $SYSTEM.TMSCHEMA_MEASURES

Query (1, 11) The syntax for 'FROM' is incorrect. (SELECT ID FROM $SYSTEM.TMSCHEMA_MEASURES).

BeaBF's avatar
BeaBF
Super User
1 year ago

saud968 Try with:
EVALUATE
SELECTCOLUMNS(
$SYSTEM.TMSCHEMA_MEASURES,
"ID", [ID],
"Name", [Name]
)

BBF

  • saud968's avatar
    saud968
    Memorable Member
    1 year ago

    Got this error


    Correlation Id: d9b7762b-f21e-1048-e33e-ca558a36c08e
    Error Details: Query (3, 1) The syntax for 'TMSCHEMA_MEASURES' is incorrect. (EVALUATE
    SELECTCOLUMNS(
    $SYSTEM.TMSCHEMA_MEASURES,
    "ID", [ID],
    "Name", [Name]
    )).

    • BeaBF's avatar
      BeaBF
      Super User
      1 year ago

      saud968 Sorry, try with:
      EVALUATE
      SELECTCOLUMNS(
      $SYSTEM.TMSCHEMA_MEASURES,
      "MeasureID", $SYSTEM.TMSCHEMA_MEASURES[ID],
      "MeasureName", $SYSTEM.TMSCHEMA_MEASURES[Name]
      )

      BBF

      • saud968's avatar
        saud968
        Memorable Member
        1 year ago


        Correlation Id: d9b7762b-f21e-1048-e33e-ca558a36c08e
        Error Details: Query (4, 39) The syntax for '[ID]' is incorrect. (EVALUATE
        SELECTCOLUMNS(
        $SYSTEM.TMSCHEMA_MEASURES,
        "MeasureID", $SYSTEM.TMSCHEMA_MEASURES[ID],
        "MeasureName", $SYSTEM.TMSCHEMA_MEASURES[Name]
        )).

        Got the above error