Why I cannot see field search for column in dax code?

[Anonymous]

Hello,
can somebody explain me why I cannot see menu for filling columns name ? and for some tables I see it ?

Here I start write "X" to use X_role field but I cannot see it and use it


but when I try it for another column from another table it works


When I fill it manualy, it throws an error that column doesn t exist, but it is exists and it is defined in previous step


what is logic behind it? Why sometimes I can use this fields and sometimes not?

[shafiz_p]

Hi @Anonymous ,

CALCULATE can’t directly reference columns from virtual tables. You need to materialize the virtual table and then iterate over it to perform the calculation.

Use itterator function, in your case use SUMX.

Hope this helps!!

If this solved your problem, please accept it as a solution and a kudos!!

Best Regards,
Shahariar Hafiz

[FreemanZ · Accepted solution]

hi @Anonymous ,

to reference added columns in virtual tables, usually we need iterator function and use new column name directly without mentioning the virtual table name.

like:

MAXX(_table, [x_mail])

COUNTROWS(

FILTER(

_table,

[x_role]="X"

)

)