topic Re: Query (1, 1) The expression specified in the query is not a valid table expression in DAX Commands and Tips

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

Anonymous — Thu, 11 Jul 2024 19:20:07 GMT

I have a mesuare created and it is working just fine in my visuals.

However, when I try to run the same DAX expression in the DAX Query view, I'm getting the follow error message:

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

I'm using a GROUP BY() subquery that I need to countrows, so the returning value is just a single value.

When I remove the COUNTROWS() of the expression, I get a table from the 'GROUP BY()' normally without any error.

Is that any limitation in the DAX Query viwer?

Thank you!

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

vicky_ — Thu, 11 Jul 2024 22:30:13 GMT

In Query view, you can only really return a table (hence why the COUNTROWS is throwing an error)
A quick hack to get to to show is to surround your expression with curly braces to force it into a table (i.e {COUNTROWS([your calculation here])}

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

Anonymous — Mon, 15 Jul 2024 07:25:10 GMT

Hi Anonymous

vicky_ Thank you very much for your prompt reply.

Can you tell me if your problem is solved? If yes, please accept it as solution.

Regards,

Nono Chen

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

Anonymous — Fri, 19 Jul 2024 16:21:57 GMT

Problem is solved!

Thank you!