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 ...
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
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
Super User
Super UserHi 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