Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Join two tables without unique column (DAX)

Hi,   I have two tables    table 1   abc_id    experiment_id     1                   10 4                   50 6                   12 3                   3   table 2   def_id  experimen...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

sdjensen: This is what I tried 

 

test = CALCULATETABLE(VALUES('table2'[def_id]),FILTER(ALL('table2'[experiment_id]),CONTAINS(VALUES('table1'[experiment_id]),'table1'[experiment_id],'table2'[experiment_id])),(COUNTROWS(table2')))

 

error: The True/False expression does not specify a column. Each True/False expressions used as a table filter expression must refer to exactly one column.

 

Whenever I try to enter 'var' and return in my measure I get syntax error

sdjensen's avatar
sdjensen
Solution Sage
9 years ago

Please make sure that you type the formala exactly like mine - I tested it with demo data in a small model I created and it works like a charm. The VAR and RETURN is cusual for this to work.

 

You should still make sure to replace ; with , and of course replace table/column names to match your own data.

 

You can't test the CALCULATETABLE syntax with a measure. The code returns a table, so if you want to test it without the return you should select 'new table' instead, but you have to leave out the countrows part then.