Table manipulation functions - These functions return a table or manipulate existing tables. VAR Test is not working and the error message "Cannot find table 'JointTable'" is displayed. as of now TABLE/COLUMN are only available for querying the model and not for enriching the model. But, they also allow you to internally iterate logic through them. Image Source. Modifies SUMMARIZECOLUMNS by omitting specific expressions from the BLANK/NULL evaluation. I also needed to create an iterator so this is where the SUMX function comes in. And thats another way of how you can apply this logic in your data models. The first syntax returns a table of a single column. Pairs rollup groups with the column added by ROLLUPADDISSUBTOTAL within an ADDMISSINGITEMS expression. DAX gets confusing at times since some functions like clauclate we have to work from outer function to inner fucntion and others from inner to oueter (as I understand). TOPN ( , [,