Forum Discussion
Does ALL function accept table variable?
HI, I tried to create a table in dax using the below code, I am getting a error message : 'The ALL function expects a table reference for argument '1', but a table expression was used.' Am I miss...
I think that is because variables are static and when you store a value/table in a variable it is stored once it is evaluated and post that you can not change its contents,
I found the solution in the DAX documentation - 'The argument to the ALL function must be either a reference to a base table or a reference to a base column. You cannot use table expressions or column expressions with the ALL function.' So that the column has to be physically present in the model.