Forum Discussion
The expression specified in the query is not a valid table expression
Hi, please I am using table variable and when i call the table name "evaluate tbl "with evaluate it works but when I use it in the context of countrows it returns the error above
*
DEFINE
VAR fsumX =
SUMMARIZE(CHA,[Employee],[YearNo],[Organisation],[MonthNamed],
"CallTimeDuration",SUM(CHA[CallTimeDuration])
)
VAR tbl =
FILTER(
fsumX,
[AvgDBanding] = "Less Than 60 Min(s)" && CHA,[Organisation] = "b" && CHA,[MonthNamed] ="November"
)
EVALUATE
COUNTROWS(tbl)
//tbl
*
I saw a similar solution that works with countrows (https://social.msdn.microsoft.com/Forums/sqlserver/en-US/42325576-064d-4fbf-bc1c-12fbd6c89728/dax-columns-in-table-variables-cannot-be-referenced-via-tablenamecolumnname-syntax?forum=sqlanalysisservices) but i could not get the quey for mine.
I will appreciate a guide on this
Thanks
7 Replies
Hi,
When I try to run the code I get an error on [AvgDBanding] does not exist.
When you add [AvgDBanding] to the FsumX / Summarize function then it will probably work.
It does work for me either as a calculated table or as a measure (with countrows, of course), but I tested it with a very simple test set.
Regards,