Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
Check it out now!Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
i am in DAX studio and i have this code... if i remove the last evaluate to just show tbl, it returns a table...BUT when i try to use this table in an COUNTROWS() function, it fails "the query specific is not a table expression) ... why?? (please dont worry about countrows, its actually adifferent calc, but testing with COUTNROWS() fails as well)
define
var tbl=
SUMMARIZE(Sales, Products[ProductKey], Sales[ProductStandardCost])
evaluate
tbl
evaluate
COUNTROWS(tbl)
Solved! Go to Solution.
hi @ilcaa722
try like:
define
var tbl=
SUMMARIZE(Sales, Products[ProductKey], Sales[ProductStandardCost])
evaluate
tbl
evaluate
{COUNTROWS(tbl)}
COUNTROWS returns a value, while a table is expected here
hi @ilcaa722
try like:
define
var tbl=
SUMMARIZE(Sales, Products[ProductKey], Sales[ProductStandardCost])
evaluate
tbl
evaluate
{COUNTROWS(tbl)}
COUNTROWS returns a value, while a table is expected here