I have a DAX variable that contains a table. How can I reference a particular column in that variable?

For example, in the below command, the EVALUATE returns an error. But it works if I replace table1 with FactInternetSales (which is the name of the table which contains that column)

define var table1=FactResellerSales
EVALUATE ROW("a",COUNTBLANK(table1[SalesAmount]))

2 Answers 2


In DAX you can't use a variable name as with tables that are defined in the model. What you can do is to use the original table names using the table variable as a filter. For instance like in the following code

    VAR tv1 =
        FILTER( Tab1, Tab1[F1] = "A" )
ROW( "a", CALCULATE( COUNTBLANK( Tab1[Value] ), tv1 ) )

In your DEFINE statement, use TABLE instead of VAR. Although a variable expression can contain a table, its usage isn't the same as an actual query table.

    TABLE table1 = FactResellerSales
    ROW("a", COUNTBLANK(table1[SalesAmount]))

DEFINE DAX Statement

TABLE DAX Statement

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.