not a valid table expression

Apr 1, 2016 at 6:20 PM
Hi, thanks for the tool. i'm having trouble getting started, though

I'm using DAX Studio 2.3.6 and connecting to an Excel PowerPivot model. It's Excel 2016, and the file is an xlsb not xlsx (don't know if that makes any difference)

I'm trying a very simple measure, to get started:

EVALUATE
(
SUM ( 
    MasterDetail[Total_Quota] 
    ) 
)

and instead of results, it gives me this message:

Query (1, ) The expression specified in the query is not a valid table expression

can you please give me a clue?
Apr 1, 2016 at 6:22 PM
nevermind, I think I have it. This tool is useful for returning Tables, or DAX statements that evaluate to tables. is that right?
Marked as answer by ecannelora on 4/1/2016 at 11:57 AM
Coordinator
Apr 1, 2016 at 10:00 PM
Yes, that is correct DAX Studio sends queries to a tabular model and displays the results. The EVALUATE statement expects a table expression and SUM returns a scalar value. So the error coming back from the model is correct.

To return a scalar value you can use the row function.

eg.
EVALUTE
  ROW( "My Sum"
  , SUM( MasterDetail[Total_Quota] )
)