Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Getting error while writing queries in DAX Studio

Hello Guys,    I have problems with DAX Studio.    For example, if write COUNTA('table'[column]) in DAX Studio, I'm getting an error called "Query (1,1) The expression specified is not valid tabl...
  • johnt75's avatar
    johnt75
    4 years ago

    Queries in DAX Studio need to return a table, not a scalar value. If you want to run individual measures you need to turn them into a table, e.g.

    EVALUATE
{
CALCULATE( SUM( 'Table'[Amount]) )
}

    The { } is the table constructor, that turns everything inside the { } into a table.

johnt75's avatar
johnt75
Super User
4 years ago

Queries in DAX Studio need to return a table, not a scalar value. If you want to run individual measures you need to turn them into a table, e.g.

EVALUATE
{
CALCULATE( SUM( 'Table'[Amount]) )
}

The { } is the table constructor, that turns everything inside the { } into a table.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thanks!