I've been trying to do this through summarize and a new table but can't for the life of me figure out how to what I need.
I have 3 tables one is an Item List which has a unique key. the other two do not have anything unique to allow them to talk to each other so they go through Item List.
All three have Item Number which is the list's key.
I need to summarize a column from each by the Item Number to allow for filtering by Item Number. How do you write a column to summarize by the key? can I summarize to the Item List table?
It seems you may create a table with below formula.If it is not your case,please share some data sample and expected output. You can upload the .pbix file to OneDrive and post the link here. Do mask sensitive data before uploading.For further,please refer to
Table = DISTINCT ( UNION ( SELECTCOLUMNS ( Table1, "List", Table1[List] ), SELECTCOLUMNS ( Table2, "List", Table2[Item list] ), SELECTCOLUMNS ( Table3, "List", Table3[Item list] ) ) )