Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Português
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])
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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsUser | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |