Sum Totals from Table2 based on week from table1

[KUNGFUPANDA559]

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

[MFelix]

Hi @KUNGFUPANDA559,

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.

Regards,

Mfelix

[KUNGFUPANDA559]

@MFelix

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])

[MFelix · Accepted solution]

Hi @KUNGFUPANDA559,

Check this link where @marcorusso explains how to make relations between tables in DAX without using the relationship model.

Can help you to achieve waht you need.

Regards,

MFelix