Forum Discussion
Join two tables without unique column (DAX)
Could you create a 3rd table that is a list of just the Experiments? You could potentially build this table using the Edit Queries and doing an append of a few tables where you only keep the Experiment columns. Now you link your Experiment table to both tables you have described.
From here, its just a matter of making a measure to count each table and add the result together.
Anonymous: Can you please explain it in little more detail. I understood the part about creating a new table with just experiment_id? What to do next?
P.S: I am new to this
In the table relationships section, link the Dimension table you just created, with the 2 other tables. Now, whenever you want to do something by Equipment ID, you use the Dimension table field instead. Power will string everything together through this table.