Forum Discussion
The expression specified in the query is not a valid table expression
Sorry, I thought your problem was in PBI.
In Dax Studio you need to use the following to check the result of a measure:
return
ROW("Result:", COUNTROWS(tbl))
Thanks for the response, the return works well for me as well, but the "countrows" function on the tbl does not work, I was using the code in dax studio and it was throwing the error, but when I executed the code (countrows)in on power bi it worked, so I am guessing am missing something
Sorry, I thought your problem was in PBI.
In Dax Studio you need to use the following to check the result of a measure:
return
ROW("Result:", COUNTROWS(tbl))
Anonymous Thanks for the solution, I had a look at the help of dax studio for "row" context but could not find it , can you send me on a link where i can see more on it.
Anonymous
There is not too much explanation in the documentation, but it is a starting point: https://docs.microsoft.com/en-us/dax/row-function-dax
Hope this helps.
Anonymous Thanks
mbbozzutoAdvocate II
Thanks - this solution definitely worked!