Forum Discussion
Sum Totals from Table2 based on week from table1
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
Hi Anonymous,
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
3 Replies
- MFelix
Super User
Hi Anonymous,
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
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
Hi Anonymous,
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