I have two tables that have a Week column in them (table1 and table2). The page is being filtered by week from table1. I'm unclear of how to create a relationship, or perhaps use filter context to establish some sense of relationship between the two.
FWIW both tables are the results of directquery
Solved! Go to Solution.
To make this work you must have a connection between week on Table1 and week on table2, however be advise that one of this table should have unique values if not the soluition is to make a table with unique values with weeks and then use it ot make the relationship between the two tables.
Can you share some example data so I can help you further.
I'm not sure of the best method to provide a sample (the dataset is extremely large). It doesn't appear as though i can add another table (DirectQuery?). I've read some things about creating a calendar table (or perhaps week table). Logically i'm looking for:
Table2Total = CALCULATE ( SUM(TABLE2[AMOUNT]),ALLSELECTED([TABLE1[WEEK])=TABLE2[WEEK])